Interested to Buy Any Domain ? << Click Here >> for more details...
What is a heap related to database ?
- 1 Answers
- 7934 Views
- TCS, University of Edinburgh, I also Faced
- E-Mail Answers
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 Reduced List of Values?
How to use subqueries with the exists operator in oracle?
Explain the use of full option in exp command.
Can you assign multiple query result rows to a variable?
what is normalisation?what are its uses?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is an oracle recycle bin?
various types of hints and their usage
What is data file?
Difference between hot backup vs. Cold backup?
What is bulk load in oracle?
State and explain about oracle instance?
Explain the use of Merge statement in oracle 11g
Explain the difference between a procedure and a function?
What is a cursor variable?
