Need to Query table reads done by a user - Forum - OpenEdge RDBMS - Progress Community

Need to Query table reads done by a user

 Forum

Need to Query table reads done by a user

  • Hi All,

    Is there any way to get the number of reads done by a particular user on a table in OE 11.5 database.

  • Yes. First of all you need to set -indexrangesize and -tablerangesize on the DB. www.jdpalmer.co.uk/.../index.php

    Once that's done you need to look at the _UserTableStat VST for the user in question. www.jdpalmer.co.uk/.../index.php

    Alternatively, there are a number of products out there that will give you the info you require without you having to write code. I recommend the free version of protop. www.dbappraise.com/protop.html

  • A slightly different version of program that shows statistics for its own session:

    ftp.progress-tech.ru/.../MyTableStat.p

  • ProTop Free gives you this information, and a few hundred other relevant data points, all in real time. Look at the attached screen shot: you can even see which line of code is being executed.

    Download at http://dashboard.dbappraise.com.

    Paul Koufalis
    White Star Software

    pk@wss.com
    @oeDBA (https://twitter.com/oeDBA)

    ProTop: The #1 Free OpenEdge DB Monitoring Tool
    http://dbappraise.com/protop.html
  • Thanks all for the information