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_at_freelists.org
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
-----------------------------------------------------------------
Received on Thu Jul 08 2004 - 15:26:17 CDT
