Re: Portable DBA: Oracle

On Thu, 9 Dec 2004 09:44:25 -0600, Jesse, Rich <Rich.Jesse_at_quadtechworld.com> wrote:
> Without looking, doesn't estimate_percent >50 cause a compute? I remember it did on ANALYZE, but I don't remember with DBMS_STATS...

I won't post all 2k of the 10046 trace but

PARSING IN CURSOR #7 len=76 dep=0 uid=64 oct=47 lid=64 tim=23455557015 hv=926033817 ad='69ede8d4'
BEGIN dbms_stats.gather_schema_stats('UTILS',estimate_percent => 51); END; END OF STMT
PARSE #7:c=100144,e=394825,p=35,cr=270,cu=0,mis=1,r=0,dep=0,og=1,tim=23455557002

generates sql of the form

insert /*+ append */ into sys.ora_temp_1_ds_14 select /*+ cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ <COLUMNLIST> from "UTILS".<TABLENAME> sample ( 51.0000000000) t

so I'd say that the answer was no. It does the sample you request.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l