To support it, recall another current thread about CBO optimizer
having too much permutations during parsing. Shooting for statistics
have good chances to fix the problem but there are enough chances that
main problem is something completely different like long parsing (and
it would explain CPU consuption but not disk IO) or whatever else.
2006/7/12, Alex Gorbachev <gorbyx_at_gmail.com>:
> If one have time to play with various troubleshooting methods than it
> better be something rather scientific like already mentioned "Method
> R". ;-)
>
> 2006/7/12, Laimutis Nedzinskas <Laimutis.Nedzinskas_at_landsbanki.is>:
> > Another approach is try to play wiht plan stability....
>
>
>
> --
> Best regards,
> Alex Gorbachev
>
> http://blog.oracloid.com
>
--
Best regards,
Alex Gorbachev
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 12 2006 - 07:42:38 CDT
