Katarina,
Please run an explain plan. Check to see what its doing.
Also is the tablespace Locally Managed?
How many extents?
Did you collect statistics previously? (Maybe it was usuing rule-based
before"
Is the datafile on the same disk as before? If not, Check the I/O on the
disk
Wade
"Katarina Laclavikova" <klaclavikova_at_europe.com> wrote in message
news:bbd8a2fb.0311030725.25c3ae98_at_posting.google.com...
> Hi all
> Last weekend, l was move index tablespace to another disk. After that,
> application running more slower.
> It doesn't use some indexes. I was rebuild indexes, collect statistics
> and application is still running slowly.
> ( SELECT which was running 20 sec, now is running 1 hour )
>
> Any comments or suggestions appreciated.
>
> Thanks
> Katarina
>
>
> Katarina Laclavikova
> klaclavikova_at_europe.com
Received on Mon Nov 03 2003 - 09:51:51 CST
