Oracle Memory Management Question:
Download Questions PDF

How will you force database to use particular rollback segment?

Answer:

For perticular transaction Alter system set rollback segment 'name';

For database, we can set in pfile. Rollback_segment='name' .

Download Memory Management Interview Questions And Answers PDF

Previous QuestionNext Question
What is meant by free extent?How can we organize the tablespaces in Oracle database to have maximum performance?