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 constitute an ORACLE Instance?

What is meant by recursive hints ?

What is the function of Lock (LCKn) Process?

What are disadvanteges of having raw devices ?

What do Redo Log Buffers contain?

What is Server Process?

What is an Integrity Constrains in Oracle?

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

Teradata: How can we know the indexed column in a table?

What is an Oracle Rollback Segment?

What are the two types of Server Configurations?

What is a Rollback segment entry ?

For more Oracle Architecture Interview Questions Click Here