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 does LGWR do?
Which parameter in Storage clause will reduce no. of rows per block?
What is PGA?
What is a Rollback segment entry ?
What are the functions of SMON?
How does Space allocation table place within a block ?
What is the function of Lock (LCKn) Process?
What is the role of PCTFREE parameter is Storage clause ?
What is an Oracle SYSTEM tablespace and when is it Created?
How to define Data Block size in Oracle?
How will you estimate the space required by a non-clustered tables?
How the space utilisation takes place within rollback segments?