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 Rollback segment entry ?
What is Shared Pool?
When Does DBWR write to the database?
What is meant by recursive hints ?
How will you create multiple rollback segments in a database ?
What are the consideration at tehe migration of Oracle 9i to 10G.
How to find the current session sid
List the Optional Flexible Architecture (OFA) of Oracle database ?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is the function of checkpoint(CKPT)?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is an Oracle Data Dictionary?