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 |
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is the use of Oracle Control File?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
How can we plan storage for very large tables ?
How will you swap objects into a different table space for an existing database?
What is an Oracle Data Block?
What is meant by redo log buffer ?
What is the function of Dispatcher (Dnnn)?
What constitute an ORACLE Instance?
What are Oracle Schema Objects?
How will you monitor the space allocation ?
How will you estimate the space required by a non-clustered tables?