Firebird - List last command from each connection

-

You can do this with this select:

select 
MON$SERVER_PID as PID,
a.MON$REMOTE_ADDRESS as IP,
a.MON$REMOTE_PROCESS as Program,
MON$PAGE_READS as DiskRead,
MON$PAGE_WRITES as DiskWriters,
s.MON$SQL_TEXT as SQL
from
MON$ATTACHMENTS a,
MON$IO_STATS i, MON$STATEMENTS s
where 
a.MON$STAT_ID = i.MON$STAT_ID 
and a.MON$ATTACHMENT_ID = s.MON$ATTACHMENT_ID
order by  MON$PAGE_READS desc

Comments

Post a Comment

Popular posts from this blog

Impacket-master - psexec for linux

-
I have an application that need to execute remote commands on Windows and linux. This app run in a CentOS server. It is easy to execute a remote on linux, but on Windows I had to search a good solution and I had find Impacket-master. To use this solution you have to follow this steps: Install python in your linux; Download this libraries; argparse-master - https://pypi.python.org/pypi/argparse   pyasn1 - https://pypi.python.org/pypi/pyasn1   pycrypto-2.6.1 - https://pypi.python.org/pypi/pycrypto Install Libraries; Unpack files: tar -vzxf pyasn1-0.1.9.tar.gz Install: python setup.py install  After this, install Ipacket-Master: python setup.py install You can find psexec.py in examples folder: impacket-master/examples These is a command line with an example: python psexec.py domain/user:password@server 'cmd /c "dir /s c:\"'
Read more

Openedge (Progress) - List transaction cache

-
Image
In Openedge database you can see last programm or SQL execution from each connection. To enable this feature first you have to connect to a database with promon. Example: $DLC/bin/promon database After this use the sequence below:   R &D 1 18 2   1, 2 or 3 At this point you can choose between th options: Single — Only the current ABL program and line number, or a single SQL statement is reported by the ABL client. Stack — The call stack up to the current ABL program and line number. One Time Request — The ABL or SQL client report tracing information once. Once reported, database-request statement caching is turned off.   After this you can use the SQLs below the get database informations: List all connections with cache information: select database() as 'Banco', c."_Connect-type" , c."_Connect-PID" as 'PID', c."_connect-ipaddress" as 'IP', c."_Connect-...
Read more