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

When does LGWR write to the database?

What is the function of Dispatcher (Dnnn)?

What is an Oracle Data Dictionary?

What constitute an ORACLE Instance?

What is Database Buffers ?

How will you monitor the space allocation ?

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

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?

What is a Control file ?

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

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

How the log writer writes the data into database

For more Oracle Architecture Interview Questions Click Here