response time [message #355042] |
Wed, 22 October 2008 06:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 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
|
|
|