RE: How to find most hit tables .
Here's one ordered for table reads:
dbaccess sysmaster << END_SQL;
select today a, sitename b,
"This report gives a list of table names and the number of hits " c,
"per table. The purpose is try and determine the most frequently " d,
"accessed tables, to allow move,emt across disks to balance i/o " e,
" Usage: tab_reads <database>" f
from systables
where tabid =
(select max(tabid) from systables);
select tabname[1,15], lockreqs, isreads, iswrites, bufreads, bufwrites
from sysptprof
where dbsname = "$1"
and (isreads>0 or iswrites>0)
order by isreads desc
>
>
>
> > 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.
> >