RE: optimizer_ ???

Based on W.Breitling's observations about oic and oica your settings
might be just fine (I was at Hotsos but did not hear this talk, but that
is one thing I recall a friend saying).  The other settings look default
also but would have to check on dynamic_sampling.=20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marquez, Chris
Sent: Friday, April 22, 2005 12:03 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: optimizer_ ???


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

--
http://www.freelists.org/webpage/oracle-l

Other related posts: