mbrugo_at_despammed.com wrote:
>Hi All,
>does anyone encountered the problem in subject.
>I 've create d a new fresh db in 9.2.0.2, imported the dump and all
>was ok.
>Now i've applyed patch 9.2.0.3 and now my queries are randomly slow.
>the same query ran in three times in 2 minute have a duration from 20
>second to 20 minute.
>
>Any suggestion ?
>
>TIA
>
>Mike
>
>
Run DBMS_STATS.
Run Explain Plan
Run DBMS_XPLAN.
Trace and use TKPROF.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Oct 08 2003 - 01:29:47 CDT
