Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Your instance has spent much of its In Oracle time waiting for the group event Rollback Segment Wait.
| Description | |
| What to do next | Perform one of the following options: n Examine the Oracle events that are grouped into the Wait for Rollback segment. Determine the dominant Oracle event and follow the tuning scenario set by this event. n Examine the statements or objects with the highest values of Rollback Segment Wait and determine which applications are creating this wait. |
| Advice | To reduce contention on the rollback segment, consider one of the following solutions: n Add rollback segments, moving them into a less busy tablespace. n Change the application flow or change the rollback policy (using no logging on specific objects). |
No comments:
Post a Comment