| response time [message #355042] |
Wed, 22 October 2008 06:28  |
ArvindBhope
Messages: 55
Registered: June 2008
|
Member |
|
|
Hi there,
For my tuning practice here the response time is critical. I just want to know which init parameters are more helpful for me in this regard.
FYI:
optimizer_dynamic_sampling integer 1
optimizer_features_enable string 10.2.0.3
optimizer_index_caching integer 0
optimizer_index_cost_adj integer 8
optimizer_mode string ALL_ROWS
optimizer_secure_view_merging boolean TRUE
thanks,
A
|
|
|
|
|
|
|
|
| Re: response time [message #355068 is a reply to message #355064] |
Wed, 22 October 2008 07:58  |
 |
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
10 steps to tuning (old Oracle doc):
Step 1: Tune the Business Rules
Step 2: Tune the Data Design
Step 3: Tune the Application Design
Step 4: Tune the Logical Structure of the Database
Step 5: Tune Database Operations
Step 6: Tune the Access Paths
Step 7: Tune Memory Allocation
Step 8: Tune I/O and Physical Structure
Step 9: Tune Resource Contention
Step 10: Tune the Underlying Platform(s)
Instance parameters come in steps 6 to 9.
Did you already make the previous steps?
Regards
Michel
[Updated on: Wed, 22 October 2008 07:59] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
