Oracle Memory Management Question:
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' .
For database, we can set in pfile. Rollback_segment='name' .
| Previous Question | Next Question |
| What is meant by free extent? | How can we organize the tablespaces in Oracle database to have maximum performance? |