Openedge (Progress) - List queries with more reads

-

Use the SQL below to list the queries with more reads in your database.

SELECT  distinct top 5 c."_Connect-IPAddress" as 'IP',
c."_Connect-Type" as 'Connection type',
c."_Connect-Name" as 'User',
c."_Connect-Pid" as 'PID',
f."_File-Name" as 'Table',
u."_UserTableStat-Read" as 'Read',
u."_UserTableStat-Create" as 'Write',
u."_UserTableStat-Update" as 'Update',
u."_UserTableStat-Delete" as 'Delete',
database() as 'Database'
FROM PUB."_UserTableStat" u, PUB."_File" f, PUB."_Connect" c
where (u."_UserTableStat-Read" > 0
or u."_UserTableStat-Create" > 0
or u."_UserTableStat-Update" > 0
or u."_UserTableStat-Delete" > 0)
and f."_File-Number" = u."_UserTableStat-Num"
and c."_Connect-Id" = u."_UserTableStat-Conn" + 1
order by u."_UserTableStat-Read" 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