High CPU and Elapsed time

[sumit]

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

[DaPi]

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.