List the factors that can affect the accuracy of the
estimations ?
Answer / orawhiz
The space used transaction entries and deleted records does
not become free immediately after completion due to delayed
cleanout.
Trailling nulls and length bytes are not stored.
Inserts of, updates to and deletes of rows as well as
columns larger than a single datablock, can cause
fragmentation an chained row pieces.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is User Process?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What do Redo Log Buffers contain?
What is the role of PCTFREE parameter is Storage clause ?
What is Shared SQL Area?
What is an Oracle Rollback Segment?
What constitute an ORACLE Instance?
How will you swap objects into a different table space for an existing database?
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 meant by recursive hints ?
What is meant by redo log buffer ?
When does LGWR write to the database?