Re: How often a table is accessed?

From: Doug Cha <dcha_at_shell2.ba.best.com>
Date: 1998/01/16
Message-ID: <69mgbg$3rk$1@nntp1.ba.best.com>#1/1

Catcox <catcox_at_aol.com> wrote:
: Does anybody know of some nifty query which would return a list of tables and
: the frequency with which they are accessed by users?

: If you know that this is not possible, I'd like to know that too.

Audit trails may help you. I'm probably the only person alive more familiar with O8 than O7 so this may not apply to < O8 databases but:

audit select table;

You'd have to compile the statistics but that shouldn't be too hard with a mediocre awk program.

-Doug Received on Fri Jan 16 1998 - 00:00:00 CST