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 are the consideration at tehe migration of Oracle 9i to 10G.
What is Shared Pool?
What is Dedicated Server Configuration?
How can we plan storage for very large tables ?
What is meant by recursive hints ?
How will you monitor rollback segment status ?
How the space utilisation takes place within rollback segments?
What is the function of Lock (LCKn) Process?
What are disadvanteges of having raw devices ?
What is the use of Oracle Control File?
What is an Integrity Constrains in Oracle?
What is the function of checkpoint(CKPT)?