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
Give the advantages and disadvantages of clusters.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
defination of bitmap index
What is the usage of save points in oracle database?
What is integrity and what is constraint??Explain with example
How to change system global area (sga) in oracle?
What is an oracle function?
Explain overloading. Can functions be overloaded?
Explain the types of exception?
How to use attributes of the implicit cursor in oracle?
What is a user role in oracle?
What is the use of aggregate functions in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How can I combine multiple rows into a comma-delimited list in oracle?
Differentiate between pre-select and pre-query?