RE: Table Hits on V7

Manoj Try looking at the sysmaster table sysptprof. It tells you the = cumulative hits on each table since the engine was started last or since = you did an onstat -z. I use the following query: select * from sysptprof where dbsname =3D "my_db_name"; HTH Sujit Pal DBA, Computer Sciences Corp. ---------- From: Manoj Shroff[SMTP:manoj@future.dsc.dalsys.com] Sent: Wednesday, October 30, 1996 3:06 AM To: informix-list@rmy.emory.edu Subject: Table Hits on V7 Hi All, Is there any way (or even a tool available) that will=20 let you see how many time a table has been hit ? [Informix v7.x, online] Thanks, ##################### Manoj Schroff (Systems Engineer) ##### ############## Dallas Systems plc ##### ### Ocean House ## * # The Ring Tel: +44 (0)1344 420144 ##### ## Bracknell Direct: +44 (0)1344 418448 ###### # Berkshire ###### #### RG12 1AH Fax: +44 (0)1344 418400 ####### ### ##### manoj@dalsys.com=20 ############# ###### manoj@pipe.demon.co.uk ############# ####### http://www.dalsys.com:8080/ ##################### http://www.pipe.demon.co.uk/ +--------------------------------------------------------------+ |"He who laughs last, obviously did not understand the joke !!"| +--------------------------------------------------------------+