fire off multiple dbms_stats.gather_schema 2004-07-08 - By Barbara Baker
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 (See ORA-06550.ora-code.com): line 1, column 87:
> PLS-00302: component 'AUTO_SAMPLE_SIZE ' must be
> declared
> ORA-06550 (See ORA-06550.ora-code.com): 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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
