Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How often a table is accessed?

Re: How often a table is accessed?

From: RWP <randy_prater_at_ibm.net>
Date: 1998/01/15
Message-ID: <34BECA7F.AA7C5405@ibm.net>#1/1

Might be able to employ Oracle auditing and then query the AUD$ table. Just a thought...
rwp

Catcox 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.
>
> Thank you,
>
> Catherine Cox
> catcox_at_aol.com
Received on Thu Jan 15 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US