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 -----------------------------------------------------------------