DEVFYI - Developer Resource - FYI

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