Re: Heavily used tables
There are some scripts I wrote that are in the IIUG repository grouped under
"Monitor", one of the scripts gets table level access counts
Regards
Colin
There are 10 types of people in the world, those that understand binary and
those that don't
>From: "Simon" <si_g_palmer@yahoo.com>
>Reply-To: "Simon" <si_g_palmer@yahoo.com>
>To: informix-list@iiug.org
>Subject: Re: Heavily used tables
>Date: 10 Oct 2005 04:42:58 -0700
>
>anjay.shah.21@talk.geekinterview.com wrote:
> > Hi,
> >
> > Is there a way of finding out which tables within the database are
> > heavily used? It does not necessarily mean new data, but could be lots
> > of queries against the tables rather than inserts.
> >
> > Normally thehe DB/App designer should know or have an idea, but I was
> > wondering if there was a way I could interogate the system tables to
> > get an idea.
> >
> > Thanks
> >
> >
> > ------------------------------------------------------------------------
>
>
>onstat -g ppf or look in sysmaster:sysptprof>
>ONCONFIG parameter TBLSPACE_STATS needs to be set to 1
>
>This would require a bounce if currently 0 (default).
sending to informix-list