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 |
What is the role of PCTFREE parameter is Storage clause ?
Which parameter in Storage clause will reduce no. of rows per block?
What are the functions of SMON?
• What is oracle Architecture?
What does LGWR do?
How to find the current session sid
What is an Oracle Data Segment?
What is meant by recursive hints ?
What is the function of checkpoint(CKPT)?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
How the log writer writes the data into database
Why query fails sometimes ?