asked on
how to trace the deadlock using alert log file?
Hi Experts,
I want to look for deadlook error in the alert log file?
I need to knwo how to trace it and how we will find the trace file for that?
I want to look for deadlook error in the alert log file?
I need to knwo how to trace it and how we will find the trace file for that?
Unix OSOracle Database
Last Comment
yuzh
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
any update on this?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I know that we have see for ORA-0060 errors in the alert.
we have follow some steps to kill one of the session which we can find in alert log.
we have follow some steps to kill one of the session which we can find in alert log.
ASKER
any update on this?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Yuzh,
We can detect deadlock in alert log.
then we have to check userdump file for that paricular time.
there we can find the whole information what actually is causing the deadlock.
that i wanted to know
byeeee...
We can detect deadlock in alert log.
then we have to check userdump file for that paricular time.
there we can find the whole information what actually is causing the deadlock.
that i wanted to know
byeeee...
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
we can find the deadlock information in the alert log file, then we have to check trace file.
I am not quite sure thats why i have posted a question.