What is a heap related to database ?
- 1 Answers
- 7166 Views
- TCS, University of Edinburgh, I also Faced
- E-Mail Answers
Answer / dhaval kodrani
There is one database heap per database, and the database
manager uses it on behalf of all applications connected to
the database. It contains control block information for
tables, indexes, table spaces, and buffer pools. It also
contains space for the log buffer (logbufsz) and temporary
memory used by utilities. Therefore, the size of the heap
will be dependent on a large number of variables. The
control block information is kept in the heap until all
applications disconnect from the database
| Is This Answer Correct ? | 8 Yes | 2 No |
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
what is insert all statement in sql
How to add a new column to an existing table with a default value?
What is difference between Rename and Alias?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
what r tyhe major differences between oracle 9i & 10g?
What is Rollback Segment ?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
What are the uses of synonyms?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
How to check database size in Oracle?
Oracle General 
