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 the use of system.effective.date variable in oracle?
How to put more than 1000 values into an oracle in clause?
What is oracle latest version?
Explain oracle data types with examples?
What is varray?
What is a cognitive schema?
How index is implemented in oracle database?
Explain enable novalidate constraint.
Explain the use of inctype option in exp command.
What is a tns service name?
What is merge statement used for?
How to define a data field as not null?
What is an index associated with a constraint?
What is SQL access advisor in Oracle?
How to write an inner join with the where clause in oracle?