Why query fails sometimes ?

Question Posted / guest

1 Answers
5043 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

Post New Answer

More Oracle Architecture Interview Questions

What is hit ratio ?

13 Answers Indiabulls, RGPV,

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 Answers

What is function of RECO?

1 Answers

What is the role of PCTFREE parameter is Storage clause ?

2 Answers

What is advantage of having disk shadowing/ Mirroring ?

1 Answers

What is a Rollback segment entry ?

3 Answers TCS,

What is an Oracle Data Block?

0 Answers

List the Optional Flexible Architecture (OFA) of Oracle database ?

1 Answers

What is the maximum number of Lock Processes used?

1 Answers

What does LGWR do?

2 Answers

What are the uses of Oracle Rollback Segment?

0 Answers

How the log writer writes the data into database

4 Answers Baidu, Satyam,

For more Oracle Architecture Interview Questions Click Here