Re: Auto Stats Job
Date: Tue, 14 Aug 2018 04:39:10 +0000 (UTC)
Message-ID: <1848832300.7437287.1534221550512_at_mail.yahoo.com>
Qaiser
I like some good tips in the document. Do we have the same for 12c too with some change as otherwise most still work for 12c. Will go more to see if I can get some optimization in the environment Sanjay
On Thursday, August 9, 2018, 12:02:56 PM EDT, Q A I S E R <qrasheed_at_gmail.com> wrote:
Hi Sanjay,
The preferred method for gathering statistics in Oracle is to use the supplied automatic statistics gathering job. You could tune the automated job so it completes succesfully. You could use parallelisim, change stale percentage, use concurrent stats by setting Gather Optimizer Statistics Default Options. You can also increase the maintenance window time, so the job completes.
Following white papaer on "Best Practices for Gathering Optimizer Statistics" may help. Please see section 'Improving the efficiency of gathering statistics'
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-optimizer-stats-04042012-1577139.pdf
Thank,--Qaiser
On Wed, Aug 8, 2018 at 4:15 PM, Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:
Hi Experts
I had question on Auto Stats job in 12c which is running for 4hr now from 10pm to 2am. I had multiple heavy used environment where lost of objects shows up for stale stats and the job failed to finish in 4 hr and so multiple critical table stats were not collected. If I am running the job as manually then can have more degree and can finish the job in less than 4 hr. So how Oracle allocated Degree when Degree defined for all database objects is 1 and what can be done to update like preference or so to complete the auto job in time. Don;t want to add layer by using cron
RgdsSanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 14 2018 - 06:39:10 CEST