How does Space allocation table place within a block ?

Question Posted / guest

1 Answers
4088 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 to define Data Block size in Oracle?

0 Answers

Why query fails sometimes ?

1 Answers

how oracle will recognise its space is 100gb if 100gb is allocated for it...

1 Answers Baidu,

How to find the SGA Size

7 Answers Baidu, Reliance,

What is an Oracle Rollback Segment?

0 Answers

What Does DBWR do?

2 Answers Honeywell,

List the Optional Flexible Architecture (OFA) of Oracle database ?

1 Answers

What does LGWR do?

2 Answers

What is the functionality of SYSTEM table space ?

3 Answers

What is Database Buffers ?

4 Answers

How will you estimate the space required by a non-clustered tables?

2 Answers

How will you swap objects into a different table space for an existing database?

2 Answers

For more Oracle Architecture Interview Questions Click Here