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

How will you monitor the space allocation ?

What is Cursor?

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

When does LGWR write to the database?

What do Redo Log Buffers contain?

What is dictionary cache ?

What is the maximum number of Lock Processes used?

How to define Data Block size in Oracle?

How can you find the size of a database?

What is advantage of having disk shadowing/ Mirroring ?

what is the role of archiever

What is an Integrity Constrains in Oracle?

For more Oracle Architecture Interview Questions Click Here