Interested to Buy Any Domain ? << Click Here >> for more details...
What is a heap related to database ?
- 1 Answers
- 7805 Views
- TCS, University of Edinburgh, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why oracle is used?
Which is faster join or subquery in oracle?
What is materialized view in Oracle?
Explain the difference between sql and oracle?
Is there a combination of "like" and "in" in sql?
State any two functions of oracle?
List the types of joins used in writing subqueries?
What is an oracle tablespace?
How to retrieve values from data fields in record variables?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to connect asp pages to oracle servers?
What is max rowid in oracle?
What is oracle latest version?
What is connection pooling in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
