Database Administration (MOSC)

MOSC Banner

Roll back is very slow andcausing performance issue.

edited Nov 26, 2013 5:15PM in Database Administration (MOSC) 5 commentsAnswered ✓
Hi All

We are hitting issue in Live instance.  I

Cause: One of the program was holding lock  and doing nothing, hence functional team cancelled the program and session was kiiled from the backend from DBA team.

Issue: After session has killed from the backend,  transaction are getting rolled back and taking long time to recover. This is causing performance issue.

Question: Is there any way to speedup the this rolling back , so that system will come to normal state ?

Findings: SMON had spawned the parallel slaves to perform the undo recovery but we do see the parallel coordinator are failing with CAUGHT Exception[Parallel Transaction recovery server caught exception 10388].

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center