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 the space utilisation takes place within rollback segments?
What is an Integrity Constrains in Oracle?
What is User Process?
Which parameter in Storage clause will reduce no. of rows per block?
What are the components of SGA?
What is meant by recursive hints ?
How to implement the multiple control files for an existing database ?
1.Explain the three levels with the help og a diagram.
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is PGA?
What is Cursor?
What is Database Buffers ?