RE: Table Access
If you have the env variable TBLSTATS set to 1 in the onconfig, you can then
query the sysptprof table (in sysmaster) for all kinds of good information
on access to the tables. Beware that this info is reset to 0 each time the
engine is on-lined and i beleive whenever a onstat -z is issued.
Hope this helps
mac
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of
> Marcus.Wilkinson@ssa.co.uk
> Sent: Tuesday, August 17, 1999 4:26 PM
> To: informix-list@iiug.org
> Subject: Table Access
>
>
> Hi,
>
> I think I have asked this question before but can't find the answer in my
> archives.
>
> How can I find out which tables within a database/server instance are
> accessed the most. I think it was a systable???????
>
> Thanks for your help.
>
> Marcus Wilkinson
>
> ________________________________
>
> The information contained in this electronic mail message is confidential.
> It is intended solely for the use of the individual or entity to
> whom it is
> addressed and others authorised to receive it. If the reader of this
> message is not the intended recipient, you are hereby notified that any
> use, copying, dissemination or disclosure of this information is strictly
> prohibited.
> ________________________________
>
>