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 a Control file ?
How will you swap objects into a different table space for an existing database?
What is an Integrity Constrains in Oracle?
What is meant by Redo Log file mirrorring ? How it can be achieved?
What constitute an ORACLE Instance?
Diference between Oracle 9i and 10G.
How free extents are managed in Ver 6.0 and Ver 7.0 ?
1.Explain the three levels with the help og a diagram.
Name the ORACLE Background Process?
What is the function of Lock (LCKn) Process?
How to implement the multiple control files for an existing database ?
How will you force database to use particular rollback segment?