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. 08-13-2004, 04:29 AM #1
    ngwh
    ngwh is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  2. 08-13-2004, 04:41 AM #2
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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
    Reply With Quote Reply With Quote
  3. 08-13-2004, 04:45 AM #3
    reydp's Avatar
    reydp
    reydp is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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