SETTING PARAMETER [message #467371] |
Fri, 23 July 2010 12:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
prashant_ora
Messages: 196 Registered: July 2010
|
Senior Member |
|
|
Hi ,
I am working on oracle 10g and I got one information on internet that if we set these parameter our performance can improve:
optimizer_secure_view_merging = false
_gby_hash_aggregation_enabled = FALSE
optimizer_index_cost_adj = 50
optimizer_index_caching = 0
_optimizer_cost_based_transformation = OFF
any one pl advice me.
|
|
|
Re: SETTING PARAMETER [message #467373 is a reply to message #467371] |
Fri, 23 July 2010 12:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
They can improve or degrade your performances depending on the case.
If they would ALWAYS improve the performances they would ALWAYS have these values and can't be modified.
The simple fact that you can set a different proves that these values won't always improve the performances.
Before reading anything on the web, you should read and understand Oracle documentation, especially Database Concepts and Database Performance Tuning Guide.
The try to understand what each parameter and what is the impact of modifying them.
For instance, what is "optimizer_secure_view_merging" and why using TRUE or FALSE?
Regards
Michel
[Updated on: Fri, 23 July 2010 12:30] Report message to a moderator
|
|
|
|