Why query fails sometimes ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are Oracle Schema Objects?

857


What is an oracle database schema?

862


What are the consideration at tehe migration of Oracle 9i to 10G.

2753


Can a View based on another View in Oracle?

840


What is an Oracle Data Block?

803


Teradata: How can we know the indexed column in a table?

1563


What is an Oracle Data Dictionary?

842


How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2465


What is an Integrity Constrains in Oracle?

936


What are the uses of Oracle Rollback Segment?

889


How to define Data Block size in Oracle?

880


What is the function of Redo Log in Oracle?

862


What is an Oracle Rollback Segment?

868


What is the use of Oracle Control File?

813


Can a Tablespace hold objects from different Schemes in Oracle?

813