Posts

Showing posts from December, 2017

OpenEdge (Progress) - List BI Writes an Reads

Sometimes you have to know who is making your BI bigger than expected. With the select below you can do that: SELECT          database() as 'Database',          u."_UserIO-Name" as 'User',          u."_UserIO-BIRead" as 'Reads',          u."_UserIO-BiWrite" as 'Writess'   FROM PUB."_UserIO" u   where u."_UserIO-BiRead" > 0 or u."_UserIO-BiWrite" > 0   order by u."_UserIO-BiWrite" desc