Re: Highest table being accessed
Hi,
Susan Elliott (ISG) wrote:
>
> Does any one know how to work out which tables in a database are being
> accessed the most ???
>
The following is a script that works with Online 7.X. This
from the articule on Exploring the sysmaster database at on my
web site.
Regards - Lester
------------------------------------------------------------------------
-- Module: @(#)tabprof.sql 1.4 Date: 97/07/18
-- Author: Lester B. Knutsen Email: lester@advancedatatools.com
-- Advanced DataTools Corporation
-- Discription: Displays table IO performance
-----------------------------------------------------------------------
database sysmaster;
-- Some of the fields are commented out so the display will fit on
-- a 80 column screen
select
dbsname,
tabname,
isreads,
bufreads,
pagreads
-- uncomment the following to show writes
-- iswrites,
-- bufwrites,
-- pagwrites
-- uncomment the following to show locks
-- lockreqs,
-- lockwts,
-- deadlks
from sysptprof
order by isreads desc; -- change this sort to whatever you need to
monitor.
--
______________________________________________________________________
Lester Knutsen lester@advancedatatools.com
Advanced DataTools Corporation Voice: 703-256-0267
Grant group privileges for Informix databases with DB Privileges
Visit our Web page: www.advancedatatools.com
Washington Area Informix User Group: www.iiug.org/~waiug/
______________________________________________________________________