What is a heap related to database ?
Answer / 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 |
What is the difference between Outer join and Full outer join?
What are the different oracle database objects?
How to select some rows from a table in oracle?
What is oracle join syntax?
What is a public synonym?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
How many memory layers are in the shared pool?
what is difference between cartesian join & cross join even they give same result?
What is oracle sid?
can a view be updated?
How many types of segments in Oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?