Why query fails sometimes ?
ORACLE Interview Questions and Answers (Part 2)
(Continued from previous question...)
307. Why query fails sometimes ?
Rollback segment dynamically extent to handle larger transactions entry loads. A single transaction may wipeout all available free space in the Rollback Segment Tablespace. This prevents other user using Rollback segments.
(Continued on next question...)
Other Interview Questions