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 open database communication (odbc) in oracle?
What is Library Cache in Oracle?
What is difference between sid and service name in oracle?
How to check the server version in oracle?
Does oracle partitioning improve performance?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
what are the default admin accounts in Oracle 10g ?
How to bring a tablespace offline?
What is Reduced List of Values?
How to end the current transaction in oracle?
What are the differences between primary key and unique key?