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 meant by redo log buffer ?
What is dictionary cache ?
What is Cursor?
What are the uses of Oracle Rollback Segment?
What is the functionality of SYSTEM table space ?
How the log writer writes the data into database
What is Shared SQL Area?
Can a View based on another View in Oracle?
what is ORACLE MEMORY STRUCTURES
What is an Oracle SYSTEM tablespace and when is it Created?
What is a Control file ?
What is an Integrity Constrains in Oracle?