+ Reply to Thread
Results 1 to 3 of 3
  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 »

Bookmarks

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