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: Problem running dbms_sql inside the procedure

RE: Problem running dbms_sql inside the procedure

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 16 Nov 2006 12:52:03 -0700
Message-Id: <20061116195133.B0A5B4B532E@turing.freelists.org>


At 12:18 PM 11/16/2006, Harvinder Singh wrote:
>Error was in the calling block so fixed it.
>"(e) Are you aware that with method_opt=> 'FOR ALL COLUMNS SIZE
>AUTO' you are generating a ton of, largely unnecessary and
>potentially dangerous (for performance), histograms?"
>I am still doing testing on this option, but am not that was a bug
>in 9i and got fixed in 10.2.0.2 where it is now doing better job.
>
>Also what is the option that you have set or recommend? Also it will
>be great of you can post some results that you gather while testing
>this option.

I use 'for all columns size 1' and gather histograms separately for select columns.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com



This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 16 2006 - 13:52:03 CST

Original text of this message

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