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 advantage of having disk shadowing/ Mirroring ?
How can you find the size of a database?
What is meant by Redo Log file mirrorring ? How it can be achieved?
What is a Parallel Server option in ORACLE?
Why query fails sometimes ?
What are the uses of Oracle Rollback Segment?
What is User Process?
What is an Integrity Constrains in Oracle?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is the function of ARCH?
What is the OPTIMAL parameter ?
What is an Oracle Data Dictionary?