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 Redo Log file mirrorring ? How it can be achieved?

What is the functionality of SYSTEM table space ?

When will be a segment released?

What is advantage of having disk shadowing/ Mirroring ?

What are the uses of Oracle Rollback Segment?

What is the use of Oracle Control File?

What is the maximum size of a oracle9i database?

When Does DBWR write to the database?

How will you monitor the space allocation ?

What is the function of ARCH?

List the Optional Flexible Architecture (OFA) of Oracle database ?

What does LGWR do?

For more Oracle Architecture Interview Questions Click Here