Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Blocking Question

Re: Blocking Question

From: <bdbafh_at_gmail.com>
Date: 18 Aug 2005 16:12:18 -0700
Message-ID: <1124406738.499359.97890@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 Received on Thu Aug 18 2005 - 18:12:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US