Download Latest Version TopThreads.zip (30.3 kB)
Email in envelope

Get an email when there's a new version of TopThreads

Home
Name Modified Size InfoDownloads / Week
TopThreads.zip 2012-11-23 30.3 kB
1 1 weekly downloads
readme.txt 2012-11-23 2.4 kB
0
Totals: 2 Items   32.7 kB 1 
Usage: 
  TopThreads.exe -t -l=40 --connect=DSN=ORCL;UID=system;PWD=manager; -p oracle --sort=1

Process    PId     TId          State           CPU         CPUDiff                      OSUser                 ORAUser                 Program    SID     Serial#
 oracle    316     6068       Running          6443         3073,22               SERVER\vogler                  SYSTEM             sqlplus.exe    131     429
 oracle    316     5200          Wait           359           31,20               SERVER\vogler                  SYSTEM          TopThreads.exe    134     3893
 oracle    316     1312          Wait         13120            0,00                      SYSTEM                               ORACLE.EXE (LGWR)    189     1
 oracle    316     3680          Wait           125            0,00         NT-AUTORITÄT\SYSTEM                  DBSNMP             emagent.exe    204     1923
 oracle    316     4044          Wait            78            0,00         NT-AUTORITÄT\SYSTEM                  DBSNMP             emagent.exe    198     11171
 oracle    316     6748          Wait            47            0,00         NT-AUTORITÄT\SYSTEM                  DBSNMP             emagent.exe    71      1247
 oracle    316     1204          Wait            31            0,00
 oracle    316     3520          Wait            31            0,00                      SYSTEM                               ORACLE.EXE (RECO)    127     1
 oracle    316     3484          Wait            31            0,00
 oracle    316     2952          Wait            31            0,00                      SYSTEM                               ORACLE.EXE (DBRM)    188     1

Parameter:
  -m, --machine=VALUE        threads from remote machine
  -p, --process=VALUE        processname filter
  -s, --state=VALUE          state filter
  -c, --connect=VALUE        connection string: DSN=ORCL;UID=system;PWD=x;
  -t                         top mode with refresh
  -l, --lines=VALUE          show n lines
  -r, --refresh=VALUE        refresh timer (seconds)
  -x, --sort=VALUE           sort 1 (cpu total), 2 (cpu diff), 3 (procname), 4 (threadid)
  -h                         help
     
 when the application runs in "Top Mode" following keys can be pressed:
 c => sort by CPU (sum)
 d => sort by CPU-Diff (change of cpu usage since last refresh)
 n => sort by processname
 p => sort by processid
 q => quit
Source: readme.txt, updated 2012-11-23