Home » RDBMS Server » Performance Tuning » response time
response time [message #355042] Wed, 22 October 2008 06:28 Go to next message
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 #355062 is a reply to message #355042] Wed, 22 October 2008 07:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
fast=true

Regards
Michel
Re: response time [message #355064 is a reply to message #355042] Wed, 22 October 2008 07:33 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
I couldn't get you mike.. could you be more clear on that?

thanks,
A
Re: response time [message #355068 is a reply to message #355064] Wed, 22 October 2008 07:58 Go to previous message
Michel Cadot
Messages: 64111
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

Previous Topic: Need help in tuning this query
Next Topic: Bitmap conversion
Goto Forum:
  


Current Time: Mon Dec 05 19:08:30 CST 2016

Total time taken to generate the page: 0.08109 seconds