High CPU and Elapsed time
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: High CPU and Elapsed time

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    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

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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
  •  



Click Here to Expand Forum to Full Width