Interested to Buy Any Domain ? << Click Here >> for more details...
What is a heap related to database ?
- 1 Answers
- 7857 Views
- TCS, University of Edinburgh, I also Faced
- E-Mail Answers
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 program global area (pga) in oracle?
What is oracle sid?
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
How to load a large xml file?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
what is the syntax of ALTER command?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to create a new oracle data file?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
How can you merge two tables in oracle?
How to use "in" parameter properly?
How to use "while" statements in oracle?
Oracle General 
