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 the role of PCTFREE parameter is Storage clause ?

Can a View based on another View in Oracle?

What constitute an ORACLE Instance?

What is meant by free extent ?

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

What is an Oracle Data Segment?

What is advantage of having disk shadowing/ Mirroring ?

What is the significance of having storage clause ?

how oracle will recognise its space is 100gb if 100gb is allocated for it...

What is an Integrity Constrains in Oracle?

What is User Process?

Why query fails sometimes ?

For more Oracle Architecture Interview Questions Click Here