Re: statistics_level='ALL' with 10046, level 8 : Cost/Benefit Analysis
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Sun, 28 Sep 2008 10:26:10 +0300
Message-id: <48DF3192.2080507@inter.net.il>
> I have a vendor that insists on running a batch job with
> statistics_level='ALL'
Date: Sun, 28 Sep 2008 10:26:10 +0300
Message-id: <48DF3192.2080507@inter.net.il>
I had a case where a system was slowed down significantly with 'all'.
Took me two months to find it and and change back to 'typical' and then
things went back to normal.
Be afraid, be very afraid.
Adar Yechiel
Rechovot, Israel
Hemant K Chitale wrote:
>
> I have a vendor that insists on running a batch job with
> statistics_level='ALL'
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Sep 28 2008 - 02:26:10 CDT