how to check for a particular SQL query how many cpu/cpu-cycles that it is consuming?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to check for a particular SQL query how many cpu/cpu-cycles that it is consuming?

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

    how to check for a particular SQL query how many cpu/cpu-cycles that it is consuming?

    hi,

    was wondering if there's a way to achive the above? does those parameters in the v$sqlarea helps?? any guru can enlighten?

    thank in advance.

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Have a look at trace & tkprof here:
    http://download-west.oracle.com/docs...4_str.htm#1018

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    if you want quick glimpse of CPU utilization, in O.S. level,
    in SOLARIS issue
    /usr/ucb/ps -aux|head

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