RE: fire off multiple dbms_stats.gather_schema

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 8 Jul 2004 21:28:11 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00999@EXCHMN3>

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_at_lifetouch.com
I said it "looked" clear - Riddick

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Barbara Baker Sent: Thursday, July 08, 2004 3:30 PM
To: oracle-l_at_freelists.org
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_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
-----------------------------------------------------------------
----------------------------------------------------------------
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 - 21:29:41 CDT