WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!
Hello,
To Summarize:
I received an alert from my Production Server where the scheduled DBMS JOB was stuck and with the error on alert log " WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=21".
I have checked the corresponding "jobxxx" trace file and found the error on dc_sequence.
Searched metalink and also googled, my bad luck i could not get a clue apart from "increasing the cache of the sequence" that the job uses.
But then the alter command also was stuck with no progress(hung). Since to let the way for the forthcoming scheduled jobs, i had happened to kill the session.
To Summarize:
I received an alert from my Production Server where the scheduled DBMS JOB was stuck and with the error on alert log " WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=21".
I have checked the corresponding "jobxxx" trace file and found the error on dc_sequence.
Searched metalink and also googled, my bad luck i could not get a clue apart from "increasing the cache of the sequence" that the job uses.
But then the alter command also was stuck with no progress(hung). Since to let the way for the forthcoming scheduled jobs, i had happened to kill the session.
0