process monitor sysinternals active window

ĚLTER SESSION SET tracefile_identifier = '10046'.Trace the session: To trace the session, use the Thread ID to attach to the process using oradebug:.Now that the process has been identified and it's activity scrutinized, there are a number of different actions you may wish to perform: = s1.paddr AND s1.SQL_HASH_VALUE = s2.HASH_VALUE AND p.spid SELECT s2.sql_text FROM v$process p, v$session s1, v$sqlarea s2 WHERE p.addr Thread ID Backg User Name OS User STATUS Session ID Serial No.ġ6723 VKRM SYS scott ACTIVE 200 (TNS V1-V3)Īdditionally you can run the following query to get the SQL Text of the current SQL: SELECT s2.sql_text Select the 'Threads' Tab from the properties window, a list of threads within the process should be displayed. Select the one you are interested in investigating (likely the one using the most CPU):Īrmed with the thread ID, you can now get the Oracle information you need about the process using various selects: SELECT p.spid 'Thread ID',.Double click on the executable to open it's properties. If you get a warning about missing symbols, this can be ignored:.Identify the executeable you are interested in (in most cases Oracle.exe). In this case we have used 'sqldeveloper.exe' as an example:.Run Process Explorer on the system where you are interested in investigating Oracle's CPU usage.Download and install Process Explorer from.Once you have the thread details you can use those to dump information from within oracle to determine what the process in question is doing, allowing you to debug its activity. This utility uses a graphical interface to allow you to monitor the cpu usage of processes and, more importantly for Oracle, individual threads. Is a standalone executable downloadable from direct link: . SOLUTION: Process Explorer Sysinternals Process Explorer ROCS - RENAPS Oracle Complicance Solution.

Process monitor sysinternals active window