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

What is meant by free extent ?

What is the functionality of SYSTEM table space ?

What is the use of Oracle Control File?

How the space utilisation takes place within rollback segments?

What is Server Process?

How to find the SGA Size

What is an Oracle SYSTEM tablespace and when is it Created?

When will be a segment released?

How the log writer writes the data into database

What is use of Rollback Segments In Database ?

what is ORACLE MEMORY STRUCTURES

How will you force database to use particular rollback segment?

For more Oracle Architecture Interview Questions Click Here