Oracle Memory Management Question:

Download Job Interview Questions and Answers PDF

How will you force database to use particular rollback segment?

Memory Management Interview Question
Memory Management Interview Question

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?