What is a heap related to database ?
- 1 Answers
- 7351 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 |
 How to use an oracle sequence generator in a mapping?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
What is a data dictionary and how can it be created?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
what r routers?
Differnce between view and index
What is system tablespace?
Is there any function in oracle similar like group_concat of mysql?
What are main difference between Stored Procedure and Functions.
How to run the anonymous block again?
What is truncate oracle?
What is meant by raw datatype?
Oracle General 
