Re: database statistics

From: <srivenu_at_hotmail.com>
Date: 13 Nov 2005 07:54:03 -0800
Message-ID: <1131897243.875650.188200@o13g2000cwo.googlegroups.com>

auditing all tables can be resource intensive. I think you are concerned with only a few tables which are used the least.
You can identify them using the statistics logical reads & physical reads in v$segment_statistics logical.
(Only problem is that these stats also get increment for DML against the tables not only SELECT's).

After identifying the tables with very low values in the above stats, you can set auditing on them.
regards
srivenu Received on Sun Nov 13 2005 - 09:54:03 CST