OraFAQ Forum: Marketplace » Command line tool for direct memory access into Oracle

Home » Other » Marketplace » Command line tool for direct memory access into Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Command line tool for direct memory access into Oracle [message #657565]

Mon, 14 November 2016 07:33

dba-bots
Messages: 17
Registered: June 2016

Junior Member

This is a follow on/re-branding of my previous command line tool called dsma. With dsm2 I've added a number of new features and some additional functionality.

A few screen shots and a peak at future updates can be found here

Download via dsm2 github repo or a tarball over on sourceforge

Brief overview:

You can now choose to either show ACTIVE or INACTIVE sessions. Running dsm2 without any args will show ALL sessions.

[oracle@localhost GNU-Linux-x86]$ ./dsm2.CDB1 -a INACTIVE
 SID                EVENT                             PROGRAM                          OSPID      STATUS  CONTAINER
  42 SQL*Net message from client         SQL Developer                                  11600   INACTIVE   CDB$ROOT
 163 SQL*Net message from client         sqlplus@localhost.localdomain (TNS V1-V3)      23223   INACTIVE   PDB1ROOT

[oracle@localhost GNU-Linux-x86]$ ./dsm2.CDB1 -a ACTIVE
 SID                EVENT                             PROGRAM                          OSPID      STATUS  CONTAINER
   1 rdbms ipc message                   oracle@localhost.localdomain (DBW0)             3307     ACTIVE   CDB$ROOT
   2 rdbms ipc message                   oracle@localhost.localdomain (TMON)             3366     ACTIVE   CDB$ROOT
   3 Space Manager: slave idle wait      oracle@localhost.localdomain (W005)            30763     ACTIVE   CDB$ROOT
   5 class slave wait                    oracle@localhost.localdomain (M000)            25171     ACTIVE   CDB$ROOT
  41 rdbms ipc message                   oracle@localhost.localdomain (LGWR)             3309     ACTIVE   CDB$ROOT

You can the focus on a particular session by using [-s SID] and specifying a delay [-d ] if you wish.

 ./dsm2.CDB1 -s 42

Time between wait     0.0014295329 secs
 WAIT# 34743 waiting for event: 'db file sequential read' P1: 'file#'=3 P2: 'block#'=26810 P3 ':blocks'=1
         command=PL/SQL EXECUTE ospid=11600 sqlhv=3763921514 psqlhv=3883908475 Class:User I/O
Time between wait     0.0000005040 secs
 WAIT# 34744 waiting for event: 'db file sequential read' P1: 'file#'=3 P2: 'block#'=26811 P3 ':blocks'=1
         command=PL/SQL EXECUTE ospid=11600 sqlhv=3763921514 psqlhv=3883908475 Class:User I/O
Time between wait     0.0027985700 secs
 WAIT# 34745 waiting for event: 'db file sequential read' P1: 'file#'=1 P2: 'block#'=2344 P3 ':blocks'=1
         command=PL/SQL EXECUTE ospid=11600 sqlhv=3763921514 psqlhv=3883908475 Class:User I/O

./dsm2.CDB1 -h
usage: dsm2
              -a [ACTIVE || INACTIVE] Default is to show BOTH
              -s [SID] prints detailed stats for a given session
              -d [delay] is the delay between updates in seconds.

[Updated on: Mon, 14 November 2016 08:17]

Report message to a moderator