What is a heap related to database ?
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 |
What do database buffers contain?
how to insert data into partitioned table partition done by Range partition
Explain alias?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
How to login to the server without an instance?
what is dynamic SGA and static SGA
What is oracle in java?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
How to check your oracle database 10g xe installation?
What is the difference between postgresql and oracle?
List the parts of a database trigger.
What is bind variable in oracle 11g?