What is a heap related to database ?
Answer Posted / 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 |
Post New Answer View All Answers
How to connect to a local oracle 10g xe server?
IS it possible to built the oracle database without setting the kernal parameters?
How to initialize variables with default values?
What are the ways tablespaces can be managed and how do they differ?
Explain the use of parfile option in exp command.
How to assign query results to variables?
What is SQL Tuning Advisor in Oracle?
What is java oracle used for?
Is postgres faster than oracle?
Explain rename?
Explain an extent?
What is difference between cartesian join and cross join?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is difference between truncate and delete?
What to do if dba lost the system password?