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 maximum number of Lock Processes used?
What is meant by free extent ?
What is PGA?
How does Space allocation table place within a block ?
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 a Control file ?
What are the functions of SMON?
How to implement the multiple control files for an existing database ?
What is an Oracle Data Segment?
How the space utilisation takes place within rollback segments?
What is an Oracle Data Block?
Can a Tablespace hold objects from different Schemes in Oracle?