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
What is tns service name?
How to retrieve data from an explicit cursor?
Why cursor variables are easier to use than cursors?
What is an oracle table?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Is it possible to insert comments into sql statements return in the data model editor ?
How do I limit the number of oracle database connections generated by weblogic server?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to call a sub procedure?
What is catalog in Oracle?
Explain the importance of .pll extension in oracle?
What are dml statements in oracle?
What is the maximum limit on the number of columns in a table?
What is the best way to do multi-row insert in oracle?
What are transaction isolation levels supported by oracle?