Interested to Buy Any Domain ? << Click Here >> for more details...
What is a heap related to database ?
- 1 Answers
- 7709 Views
- TCS, University of Edinburgh, I also Faced
- E-Mail Answers
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 |
Can we create trigger on view in oracle?
How to get a create statement for an existing table?
What is a table index in oracle?
Why we choose emp number as primarykey?
Does facebook use oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to start your 10g xe server from command line?
what is meant by magic query
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
When do you get a .pll extension in oracle? Explain its importance
What are the execution control statements?
What are the components of Physical database structure of Oracle Database?
Oracle General 
