Oracle Memory Management Interview Preparation Guide
Download PDF
Add New Question

Oracle Memory Management Interview Questions and Answers will guide us that Oracle Memory management is the act of managing computer memory. This involves providing ways to allocate partions of memory to programs at their request, and freeing it for reuse when no longer needed. The management of main memory is critical to the computer system. So learn the basics and advance level Oracle Memory Management with the help of this Oracle Memory Management Interview Questions with Answers guide

61 Memory Management Questions and Answers:

1 :: What is the significance of having storage clause?

We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free for managing row updations etc.
Post Your Answer

2 :: What is the functionality of SYSTEM table space?

To manage the database level transactions such as modifications of the data dictionary table that record information about the free space usage.
Post Your Answer

3 :: How does Space allocation table place within a block?

Each block contains entries as follows
Fixed block header
Variable block header
Row Header,row date (multiple rows may exists)
PCTEREE (% of free space for row updation in future).
Post Your Answer

4 :: What is the role of PCTFREE parameter is storage clause?

This is used to reserve certain amount of space in a block for expansion of rows.
Post Your Answer

5 :: What is the OPTIMAL parameter?

To avoid the space wastage we use OPTIMAL parameter.
Post Your Answer
Add New Question