RE: fire off multiple dbms_stats.gather_schema
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 Jul 2004 21:28:11 -0500
Thanks Barbara
I realized after I sent that reply that I had goofed. Then I got called
into a meeting and couldn't reply. Thanks for clarifying it for people that
might have been misled.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
I said it "looked" clear - Riddick
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Barbara Baker
Sent: Thursday, July 08, 2004 3:30 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: fire off multiple dbms_stats.gather_schema
hummmm
works for me - ?
exec dbms_stats.gather_schema_stats -
(ownname=> 'SCOTT', -
cascade=>TRUE, -
degree => 4, -
estimate_percent=>dbms_stats.auto_sample_size,
-
options =>'GATHER');
>
> BEGIN dbms_stats.gather_schema_stats(ownname=>
> 'SGRANT'
>
,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,cascade=>TRUE,block_sample=>T
RUE
> ,degree=>4,options=>'GATHER
> EMPTY',GRANULARITY=>'PARTITION'); END;
>
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 87:
> PLS-00302: component 'AUTO_SAMPLE_SIZE' must be
> declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> If I replace DBMS_STATS.AUTO_SAMPLE_SIZE with 10,
> then I receive no error.
> I also tried quotes...sigh...what is the solution?
> Thanks
> --
> ..
> David
>
> > The sample size auto just takes too long for us,
> although I might give
> > that another evaluation as last time I played with
> it was also with
> > histograms.
> >
> > We plan on using gather monthly and gather empty
> weekly...
> > --
> > ..
> > David
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
