RE: fire off multiple dbms_stats.gather_schema
- From: Barbara Baker <barbarabbaker@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 8 Jul 2004 13:29:37 -0700 (PDT)
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=>TRUE
> ,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
-----------------------------------------------------------------
Other related posts:
