Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How often a table is accessed?
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