Oracle Memory Management Question:

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' .


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