Re: statistics_level='ALL' with 10046, level 8 : Cost/Benefit Analysis

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 thenthings 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 withstatistics_level='ALL'

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: statistics_level='ALL' with 10046, level 8 : Cost/Benefit Analysis
From: Allen, Brandon

References:
- statistics_level='ALL' with 10046, level 8 : Cost/Benefit Analysis
  - From: Hemant K Chitale

Other related posts: