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 Cursor?

How to define Data Block size in Oracle?

What is a Control file ?

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

What is the function of Lock (LCKn) Process?

When Does DBWR write to the database?

How will you swap objects into a different table space for an existing database?

What is function of RECO?

How will you monitor rollback segment status ?

What is a Multi-threaded Server Configuration?

What is an Integrity Constrains in Oracle?

What are the components of SGA?

For more Oracle Architecture Interview Questions Click Here