How does Space allocation table place within a block ?

Question Posted / guest

1 Answers
4014 Views
I also Faced
E-Mail Answers

How does Space allocation table place within a block ?..

Answer / orawhiz

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Architecture Interview Questions

How the log writer writes the data into database

4 Answers Baidu, Satyam,

Can a View based on another View in Oracle?

0 Answers

What is Dedicated Server Configuration?

2 Answers IR Consulting,

What are the consideration at tehe migration of Oracle 9i to 10G.

0 Answers Baidu,

What is an Oracle Data Segment?

0 Answers

What is an Oracle Data Dictionary?

0 Answers

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

0 Answers

What is an Oracle Rollback Segment?

0 Answers

What is the function of checkpoint(CKPT)?

4 Answers

What is Cursor?

2 Answers Virtusa,

What are disadvanteges of having raw devices ?

1 Answers

What is the function of Lock (LCKn) Process?

1 Answers

For more Oracle Architecture Interview Questions Click Here