Re: Oracle 10g upgrade - performance issue

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@xxxxxxxxx>:
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@xxxxxxxxxxxxx>:
> 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


Other related posts: