Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

[suse-oracle] Deadlock detected.Details from v$xxx tables ?

Reinhard Weh

2006-02-02

Replies:

Hello,

sometimes we got the following errors from Oracle 9.2.0.6 on SLES9

/opt/oracle/admin/B1/bdump/alert_B1.log
ORA-000060: Deadlock detected. More info in file
/opt/oracle/admin/B1/udump/b1_ora_32201.trc.
ORA-000060: Deadlock detected. More info in file
/opt/oracle/admin/B1/udump/b1_ora_32201.trc.

In the trc-files there are very detail info why this occur.
But can the our developers alos got these details info (for example the
session-ids from the session which are the reason of the deadlock) from
any v$xx (systables) also to handle in the application ?

regards
Reinhard Weh



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.