Re[2]: How to find most hit tables .

Posted in 1998

Sujit.Pal@alltel.com — Fri, 25 Sep 1998 13:12:45 -0500 — source: Informix-list mailing list archive (1991-1998)

Rajesh You can find the top 5 tables being used from the SMI table sysptprof. You need to define what "used" is, since it gives you information of number of reads, writes, etc. HTH Sujit ______________________________ Reply Separator _________________________________ Subject: RE: How to find most hit tables . Author: Rajesh Ya <yarajes@wal-mart.com> at internet Date: 09/25/1998 11:23 AM > Hi, All > > > INFORMIX-OnLine Version:- 7.23.UC1X1 > O/S HP-UX B.10.20 > A 9000/889. > > How do I find out, what the top 5 programs using the > top 5 tables. In other words, what are the top 5 programs and what are > the top 5 tables being used. >