| Parameters changed in INIT.ora [message #65550] |
Mon, 25 October 2004 20:09  |
Milind Deshpande
Messages: 93
Registered: May 2004
|
Member |
|
|
Hi All,
I have changed these parameters in my INIT.ora file I just wanted to know that changing these parameters can cause any performance degrade because I have changed it for a particular SQL statement. Will this change give me better performance for all SQL queries or there may be some performance degrade.
optimizer_index_caching=60 (Modifed by 99)
optimizer_index_cost_adj=20
optimizer_mode=first_rows
Kindly help me on this .
Thanks in Advance
Milind
|
|
|
|
| Re: Parameters changed in INIT.ora [message #65553 is a reply to message #65550] |
Mon, 25 October 2004 22:03  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Don't touch your db-parameters just to tune 1 query !!
If you have an otherwise good performing system, it is very likely you
a) ruin the rest of your performance by changing these parameters
b) have just 1 crappy query, which should by tuned by changing the QUERY !
If you need to ask what consequences there are: DO NOT TOUCH those parameters.
hth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
