Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Portable DBA: Oracle

Re: Portable DBA: Oracle

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 9 Dec 2004 16:02:01 +0000
Message-ID: <7765c89704120908021194c151@mail.gmail.com>


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
Received on Thu Dec 09 2004 - 09:59:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US