Re: same query is now 30 times slower
From: Robert Malikian <malikian_at_malikian.homechoce.co.uk>
Date: Sun, 24 Mar 2002 09:35:02 -0800
Message-ID: <3c9d9c63$1_at_news1.homechoice.co.uk>
Date: Sun, 24 Mar 2002 09:35:02 -0800
Message-ID: <3c9d9c63$1_at_news1.homechoice.co.uk>
Yes!
Check your extents from dba_segments on those tables. I am sure they must
run in 1000s maybe more.
To correct it;
If table then
- do a backup hot or cold
- exp the tables compress = y
- dorp the tables or truncte
- imp If index then
- re-build then
Good luck
Robert
"Jason Separovic" <sepo_at_bigpond.net.au> wrote in message
news:gvWm8.1978$EE4.6988_at_news-server.bigpond.net.au...
> 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.
>
>
>