Re: How often a table is accessed?

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

Without resorting to placing a trigger on every table in question or on your system check out the 'audit' command and features that come with Oracle. This may prove good enough for your needs. Warning, use of the audit feature can generate a lot of data that can fill the system tablespace ( Not a good thing! ) or you can write to the OS, but accessing the data is not as easy as when you keep it in Oracle.

Good Luck.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Thu Jan 15 1998 - 00:00:00 CST