Logo F2FInterview

Memory Management Interview Questions

Q   |   QA
‹‹ previous12345678910 ... 1213

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.

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

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

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

To avoid the space wastage we use OPTIMAL parameter.

‹‹ previous12345678910 ... 1213

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: