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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marquez, Chris Sent: Friday, April 22, 2005 12:03 PM
To: oracle-l_at_freelists.org
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 Received on Fri Apr 22 2005 - 13:14:36 CDT