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:
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.
Thanks all for the information