Why Query Fails Sometimes?

1.	Why Query Fails Sometimes?
Answer» 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. 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.

Answer»

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Components Of Logical Database Structure Of Oracle Database?
What Is A Tablespace?
What Is System Tablespace And When Is It Created?
Explain The Relationship Among Database, Tablespace And Data File.
What Are Schema Objects?
Can Objects Of The Same Schema Reside In Different Tablespaces?
Can A Tablespace Hold Objects From Different Schemes?
What Is Oracle Table?
What Is An Oracle View?
Do A View Contain Data?

Why Query Fails Sometimes?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment