You can see locks in Enterprise Manager Lock Manager.
If having a deadlock, Oracle will resolve it
automatically and will generate a trace file in udump,
do a grep deadlock *.trc in the udump directory.
- Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk> a
icrit:
> Tom,
> Which monitoring tool are you using?
> TIA
> Aleem
>
>
> -----Original Message-----
> From: blair_at_pjm.com [mailto:blair_at_pjm.com]
> Sent: 26 April, 2000 9:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Deadlocks
>
> A monitoring tool that we use here is reporting
> that our
> database has a
> deadlock. We have not noticed it and there are no
> complaints.
>
> I challenged the company to tell me how they
> determine this.
> They are checking
> the v$sysstat for the value of "enqueue deadlocks"
> which in
> this case is 1.
>
> Is this correct? Is there a change from V7.x to
> 8.1.5 in
> how you would
> determine a deadlock condition?
>
> thanks,
>
> ..tom
>
>
>
>
> --
> Author:
> INET: blair_at_pjm.com
>
> Fat City Network Services -- (858) 538-5051
> FAX: (858)
> 538-5051
> San Diego, California -- Public Internet
> access /
> Mailing Lists
>
>
> To REMOVE yourself from this mailing list, send an
> E-Mail
> message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be
> removed from).
> You may
> also send the HELP command for other information
> (like
> subscribing).
>
> ATTACHMENT part 2 application/ms-tnef
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Talk to your friends online and get email alerts with Yahoo! Messenger.
Received on Thu Apr 27 2000 - 05:04:16 CDT