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

Home -> Community -> Mailing Lists -> Oracle-L -> optimizer_ ???

optimizer_ ???

From: Marquez, Chris <CMarquez_at_aarp.org>
Date: Fri, 22 Apr 2005 13:02:35 -0400
Message-ID: <7E412C164E6ECB468834A39F31E6E0D4074B5FB1@mbs06dc.na.aarp.int>

As a DBA should I be embarrassed?...
...besides optimizer_mode, I have never set any of these!
Suggestions, articles, links, etc?
Any "silver bullets" here?

SQL> show parameter opt

NAME                                 TYPE	VALUE
------------------------------------ -------	--------

...
optimizer_dynamic_sampling integer 1 optimizer_features_enable string 9.2.0 optimizer_index_caching integer 0 optimizer_index_cost_adj integer 100 optimizer_max_permutations integer 2000 optimizer_mode string CHOOSE

Thanks,

Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 22 2005 - 13:08:23 CDT

Original text of this message

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