-
High CPU and Elapsed time
Hi All,
Here is the statistics for lot of queries like below. Can you suggest me what should I tune to reduce CPU time and Elapsed time? There seems to be a lot of disk access on the guiding queries....(looking at the tkprof/statspack output)
This is for select
==================
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- 141,056,034 980,512 143.9 31.2 936.67 7409.57 1471147578
35,997,930 1,355,860 26.5 8.0 1036.90 11038.71 1375283132
This is for insert
===================
6,688,685 13,464 496.8 1.5 289.60 5055.68 1693551448
Regards
sumit
-
Please use the code tags # to format your data. It's almost incomprehensible like that.
If those selects are for about 1 million executions, I'd say you're doing OK. To improve, take one query at a time and work on that.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|