Need to Query table reads done by a user

Posted by karasanr on 13-Jul-2016 03:48

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.

All Replies

Posted by James Palmer on 13-Jul-2016 03:54

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

Posted by George Potemkin on 13-Jul-2016 04:31

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

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

Posted by Paul Koufalis on 13-Jul-2016 08:51

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.

Posted by karasanr on 26-Jul-2016 02:27

Thanks all for the information

This thread is closed