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

List the factors that can affect the accuracy of the estimations ?

What is the use of Oracle Control File?

What is use of Rollback Segments In Database ?

What is meant by redo log buffer ?

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

How will you monitor the space allocation ?

What is the function of checkpoint(CKPT)?

What constitute an ORACLE Instance?

What is Shared Pool?

What is PGA?

What is User Process?

How to find the SGA Size

For more Oracle Architecture Interview Questions Click Here