Why query fails sometimes ?
- 1 Answers
- 5105 Views
- I also Faced
- E-Mail Answers
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 |
More Oracle Architecture Interview Questions
What does LGWR do?
What is a Parallel Server option in ORACLE?
List the factors that can affect the accuracy of the estimations ?
How to find the SGA Size
What is the maximum number of Lock Processes used?
What is an Integrity Constrains in Oracle?
What are Oracle Schema Objects?
What is an Oracle Data Dictionary?
What is Shared SQL Area?
Can a View based on another View in Oracle?
When does LGWR write to the database?
What are the components of SGA?
Oracle General 
