Re: same query is now 30 times slower

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:30:16 CST