Re: Tracing SQL to find out what is causing hangs

From: Yong Huang <yong321_at_yahoo.com>
Date: 6 Aug 2003 15:19:19 -0700
Message-ID: <b3cb12d6.0308061419.53e9e8fb@posting.google.com>

Philip Nelson <teamdba_at_scotdb.com> wrote in message news:<pan.2003.08.06.15.47.10.138999_at_scotdb.com>...
>
> What I'd like to do is monitor the SQL going through the system in the
> background to have a complete picture of what is happening up until the
> point of the hang.

The view to look at what sessions are doing at the moment is v$session_wait. You need some experience with the wait events reported in there. Depending on the event you see, you may need to look at v$lock / v$locked_object, v$latch / v$latch_children,... and definitely v$session and v$sql. If that doesn't solve the problem and you need serious troubleshooting for a database hang, an "oradebug hanganalyze" in svrmgrl (or sqlplus '/ as sysdba') may be needed.

Yong Huang Received on Wed Aug 06 2003 - 17:19:19 CDT