Re: same query is now 30 times slower

From: daniel <test_at_test.com>
Date: Sat, 23 Mar 2002 12:44:37 -0000
Message-ID: <a7ht87$dvi$1@news8.svr.pol.co.uk>

have any of the tables been analysed between the good and bad performance?

daniel...

"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message news:3c9c74fe.1089034_at_news-vip.optusnet.com.au...
> Jason Separovic doodled thusly:
>
> >Has anyone ever experienced a problem where a nested select statement
which
> >first took a minute now takes half an hour. It is the exact same query on
> >the exact same dataset on the exact same database.
>
> and the stats are the same?
> run a query on v$sqlarea, find out the statement in question and pull
> out the I/O it's using. Check out an explain plan on the SQL as well.
> A combination of these will tell you what's wrong.
>
>
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Sat Mar 23 2002 - 06:44:37 CST