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 a Parallel Server option in ORACLE?

What are the uses of Oracle Rollback Segment?

What is a Multi-threaded Server Configuration?

What is advantage of having disk shadowing/ Mirroring ?

What is meant by free extent ?

What are functions of PMON?

What is User Process?

What is an Oracle Data Segment?

How will you monitor the space allocation ?

Can a Tablespace hold objects from different Schemes in Oracle?

What is the role of PCTFREE parameter is Storage clause ?

What is an Oracle Data Dictionary?

For more Oracle Architecture Interview Questions Click Here