| SETTING PARAMETER [message #467371] |
Fri, 23 July 2010 12:20  |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
