Re: need help on statspack report, Parse CPU to Parse Elapsd %

"VC" <boston103_at_hotmail.com> wrote in message news:noz2c.196154$uV3.795903_at_attbi_s51...
> Joe,
>
> "Joe" <yung103_at_netvigator.com> wrote in message
> news:c2e5m7$du45472_at_imsp212.netvigator.com...
> > Thanks a lots for the information of DV and DJ.
> > It is the Oracle eBusiness Suite, and Oracle not recommend us to make
> > changes to the whole system.
> > And in fact we don't have enough manpower to change that.
> >
> > Any advise for me to reduce the enqueue wait and latch free wait. These
2
> > numbers are making me uncomfortable.
>
> Firstly, you need to produce a report for a smaller interval ( 10-15
min )
> during a typical load. A five-hour report is hardly useful.

agreed.

>
> Pls. re-read what I wrote about enqueues. They are not a problem but a
> symptom of a possible problem with sessions probably locking the same
> rows(s). If this is the case, you need to fix the application. In order
> to determine who blocks whom, you can use the following statement:

Could be tricky given that this is e-business suite, unless there are missing indexes or what have you causing too many rows to be locked for update.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK