Why query fails sometimes ?
Answer / orawhiz
Rollback segment dynamically extent to handle larger
transactions entry loads.
A single transaction may wipeout all avaliable free space
in the Rollback Segment Tablespace. This prevents other user
using Rollback segments.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the significance of having storage clause ?
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?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is SGA?
What is an Oracle SYSTEM tablespace and when is it Created?
How to find the SGA Size
What is meant by free extent ?
What Does DBWR do?
What does LGWR do?
what is ORACLE MEMORY STRUCTURES
How will you monitor rollback segment status ?
What are the consideration at tehe migration of Oracle 9i to 10G.