| Template to capture Details about successful Oracle Performance Improvement [message #360964] |
Mon, 24 November 2008 08:15  |
gkodakalla
Messages: 49
Registered: March 2005
|
Member |
|
|
Hi everyone,
Suppose we have few queries which are having performance issues. Users complain the queries are not running
as per their expecations (say their requirement is it should run in 1 second, but it is running in 10 seconds)
We work towards improving the performance and we are able to succeed.
Now, if we want to capture all the required information about the success of the Tuning exercise,
what are the items i need to think about. From the response time point of view, we can say before the exercise, query was returning output in 10 seconds, now it is giving output on 1 second.
Can some one advice (or give me a URL) to find out what are all the parameters we can capture to show in the oracle performance improvement exercise (CPU utilization,etc) other than the response time alone?
Thanks,
Giridhar
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
