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 ORACLE MEMORY STRUCTURES
Why query fails sometimes ?
When Does DBWR write to the database?
Can a Tablespace hold objects from different Schemes in Oracle?
What is the significance of having storage clause ?
What is an oracle database schema?
What is Shared SQL Area?
How the space utilisation takes place within rollback segments?
How does Space allocation table place within a block ?
What is a Multi-threaded Server Configuration?
What is meant by free extent ?
What is the function of ARCH?