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 Cursor?
What is meant by redo log buffer ?
How will you create multiple rollback segments in a database ?
How will you force database to use particular rollback segment?
What is an Oracle Data Segment?
How will you monitor the space allocation ?
What is the function of Redo Log in Oracle?
What is a Control file ?
Which parameter in Storage clause will reduce no. of rows per block?
What is Shared Pool?
What is the role of PCTFREE parameter is Storage clause ?
Name the ORACLE Background Process?