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 main def between plsql/table and array?
What happens if you set the sga too low in oracle?
What is a trigger and what are its types?
When system tablespace is created?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
What is an oracle user role?
What is Private Database Link ?
What is a initialization parameter file in oracle?
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
What is the maximum limit on the number of columns in a table?
Define Normalization with example?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,