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