Re: Session With oper EXCL is also waiting - where to now? (systemstate dump)

On Thu, Sep 20, 2012 at 12:54 AM, Tanel Poder <tanel_at_tanelpoder.com> wrote:

> Yep, hanganalyze requires the instance to be up (or well, at least the SGA
> memory to still be readable). In past I've written scripts that log in and
> sleep until X sessions have been waiting for event Y for more than Z
> seconds - and then run hanganalyze level 3 or 4 automatically. But in 11g
> DIAG should do this for us ... or whatever process does this stuff this
> month :-) This assumes that DIAG itself isn't stuck of course :)
>
> Tanel.
>
>

--
http://www.freelists.org/webpage/oracle-l