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 free extents are managed in Ver 6.0 and Ver 7.0 ?

What is Shared Pool?

What are the consideration at tehe migration of Oracle 9i to 10G.

How the space utilisation takes place within rollback segments?

What is a Parallel Server option in ORACLE?

What is the maximum size of a oracle9i database?

What are the functions of SMON?

How will you estimate the space required by a non-clustered tables?

What is the function of checkpoint(CKPT)?

What is Dedicated Server Configuration?

How to find the current session sid

For more Oracle Architecture Interview Questions Click Here