Interested to Buy Any Domain ? << Click Here >> for more details...
What is a heap related to database ?
- 1 Answers
- 7711 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 the difference between restoring and recovering?
How to run create database statement again?
Why do you create or replace procedures rather that drop and recreate.
What happens in oracle commit?
What is the difference between "as" and "is" in an oracle stored procedure?
What is pragma autonomous transaction in oracle?
What is connection pooling in oracle?
How to convert characters to times in oracle?
What is max rowid in oracle?
What is oracle rowcount?
What is index in Oracle?
Can multiple columns be used in group by in oracle?
What are triggers in oracle?
How to create a single index for multiple columns?
How will you identify oracle database software release?
