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 Server Process?

What is the function of Lock (LCKn) Process?

What is meant by redo log buffer ?

What are disadvanteges of having raw devices ?

Which parameter in Storage clause will reduce no. of rows per block?

How to define Data Block size in Oracle?

What is the maximum size of a oracle9i database?

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

How will you monitor the space allocation ?

What is Dedicated Server Configuration?

What is use of Rollback Segments In Database ?

How will you force database to use particular rollback segment?

For more Oracle Architecture Interview Questions Click Here