DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: CPU usage of each active sessions?

  1. #1
    Join Date
    Jun 2001
    Posts
    103
    Hi all.
    OS : WIN2000 SERVER
    DB : ORACLE 8.1.7
    Task manager in NT/2000 display cpu usage for processes and can not display cpu usage for threades of one process.
    Can anybody tell me which tools (In NT/2000 or oracle) can display cpu usage for active sessions(user&background processes) that are threads of ORACLE process.

    -- sorry for my english.
    best regards.

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Maybe you can obtain so that you want with Oracle Performance Manager.

    Hope that helps

    Angel

  3. #3
    Join Date
    Mar 2001
    Posts
    149
    Maybe this is what you're looking for:
    ---
    select disk_reads,substr(sql_text,1,1000),username
    from v$sqlarea a,v$session b
    where a.address = b.sql_address
    order by disk_reads desc
    ---
    Thanks


  4. #4
    Join Date
    Jun 2001
    Posts
    103
    Thanks friends.
    More Info :
    My server (compaq proliant 7000) has 4 CPU and 3 CPU assigned to ORACLE process.
    Sometime one(or more) bad query causes 3 CPU reach
    %100 cpu time , and I want find bad query. in this situation oracle tools(like OEM or even SQL*PLUS) runs very slow , and I want OS tools(command) for finding session(s)(threads) that consume all CPU.
    I now using Top Session in OEM for finding session(s) that use more CPU in this situation.
    But what is different between this 2 item in user statistic filter :
    a) CPU used by this session
    b) recursive CPU usage

    -- sorry for my english

    Best Regards.


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