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 |
How the space utilisation takes place within rollback segments?
What is a Multi-threaded Server Configuration?
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is Cursor?
How will you force database to use particular rollback segment?
What is meant by free extent ?
Name the ORACLE Background Process?
How to find the current session sid
Why query fails sometimes ?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
What is an oracle database schema?
What is advantage of having disk shadowing/ Mirroring ?