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 |
How to enter a new row into a table interactively?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
How can we force the database to use the user specified rollback segment?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
What is the usage of analyze command in oracle?
What is oracle open database communication (odbc)?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is max rowid in oracle?
What is the usage of save points in oracle database?
How to see the table columns used in an index?
What is a cursor in oracle?
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?