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 |
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to turn on or off recycle bin for the session?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
What is meant by raw datatype?
What are steps required to ENTER DATA INTO DWH?
How can we find the size of a database?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
how to find the second highest salary in a given table????
what is candidate key & super key
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
How would you begin to troubleshoot an ORA-3113 error?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance