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

How free extents are managed in Ver 6.0 and Ver 7.0 ?

How the space utilisation takes place within rollback segments?

When Does DBWR write to the database?

What is the function of checkpoint(CKPT)?

When does LGWR write to the database?

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

How the log writer writes the data into database

What is advantage of having disk shadowing/ Mirroring ?

What is the function of Redo Log in Oracle?

What is an oracle database schema?

What is an Oracle SYSTEM tablespace and when is it Created?

Name the ORACLE Background Process?

For more Oracle Architecture Interview Questions Click Here