Re: Blocking Question

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Fri, 19 Aug 2005 12:32:51 +0200
Message-ID: <4305b553$0$14248$ba620e4c@news.skynet.be>

<bdbafh_at_gmail.com> wrote in message
news:1124406738.499359.97890_at_g44g2000cwa.googlegroups.com...
> this might be worth a read (for one possible cause)
>
> Interested Transaction List (ITL) Waits Demystified
> http://www.dbazine.com/oracle/or-articles/nanda3
>
> V$SEGMENT_STATISTICS to the rescue ...
>
> Far better though to actually identify the wait, rather than just
> postulating.
>
> -bdbafh
>

Very good article ... very good ... However possibly outdated for Oracle 9i/10g. Received on Fri Aug 19 2005 - 05:32:51 CDT