How will you force database to use particular rollback segment?

How will you force database to use particular rollback
segment?

Question Posted / guest

How will you force database to use particular rollback segment?..

Answer / orawhiz

SET TRANSACTION USE ROLLBACK SEGMENT rbs_name

Is This Answer Correct ?

2 Yes

0 No

More Oracle Architecture Interview Questions

When Does DBWR write to the database?

How can we plan storage for very large tables ?

What is the maximum number of Lock Processes used?

What are disadvanteges of having raw devices ?

What is Dedicated Server Configuration?

What is use of Rollback Segments In Database ?

What is SGA?

How to find the SGA Size

What is a Control file ?

1.Explain the three levels with the help og a diagram.

How to find the current session sid

what is ORACLE MEMORY STRUCTURES

For more Oracle Architecture Interview Questions Click Here