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 a cognitive schema?
Explain do view contain data?
How to empty your oracle recycle bin?
How to write a query with a right outer join in oracle?
What do you understand by a database object?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
what is Single Byte Overhead...?
What are the different types of modules in oracle forms?
Explain the use of compress option in exp command.
What is a data lock in oracle?
What is Trigger in Oracle?
How to create a new view in oracle?
Is oracle a language?
what are actual and formal parameters?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.