Re: Monitoring table access

In a previous episode: > From: Tod Kehrli <72064.1721@CompuServe.COM> > Subject: Monitoring table access > Date: Wed, 11 Oct 1995 18:32:54 -0500 > To: informix-list@rmy.emory.edu > X-Informix-List-To: christie@platinum.com > X-Informix-List-Id: <news.17847> > > Is there any way to monitor application access to specific > tables (i.e. # of selects in a day)? I'm trying to measure > system usage without putting hooks into the application. > It depends on the version you're running. If you are running version 7, then it is possible to get very detailed information on table i/o via the SMI tables: select dbsname, -- database name owner, -- table owner tabname, -- table name pf_dskreads, -- disk reads pf_isread, -- row reads pf_dskwrites, -- disk writes pf_iswrite, -- row writes pf_isrwrite, -- row updates pf_isdelete, -- row deletes pf_bfcread, -- buffer reads pf_bfcwrite, -- buffer writes pf_seqscans -- sequential scans from sysptntab a, systabnames b where a.partnum = b.partnum; This information is available while the table is being used. Once the table is not being used, this information is no longer available. Hope this helps. ---- WARNING -- "advertising" follows: DB-Vision for Informix from PLATINUM technology is a performance monitor for Informix databases that provides this information in graphical and tabular format. DB-Vision can also track performance history, so that statistics on table i/o can be analyzed even after the table is no longer being used. For a more complete listing of features of DB-Vision for Informix, please send email to christie@platinum.com. PLEASE - do not send requests to this mailing list ! Thanks. Rick ----------------------------------------------------------------------- | Rick Christie | PLATINUM technology, inc. | | Lead Developer, DB-Vision for Informix | 620 W. Germantown Pike | | christie@platinum.com | Suite 200 | | (610) 940-6020 | Plymouth Meeting, PA 19462 | | (610) 940-6021 (fax) | | ----------------------------------------------------------------------- | He asked me for advice. I said, "Use the door." | | -- Chrissie Hynde | ----------------------------------------------------------------