Re: Montioring table usage

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 23 Jan 2007 09:02:12 -0800
Message-ID: <1169571732.153461.139410@j27g2000cwj.googlegroups.com>

Rob Cowell wrote:
> Using Oracle 10.2
>
> Is there a way to monitor table usage in a similar way to MONITOR USAGE
> for indexes? I have a test database with what I suspect are Gigabytes
> of unused tables, but it's hard to get developers to admit they don't
> use them anymore.
>
> Thanks

You can also use dba_hist_seg_stat if you have alicense to use the AWR performance views. If not, you can accumlate your own by periodically querying v$segment_statistics (physical read, logical reads, and physical writes, etc.).

HTH, Steve Received on Tue Jan 23 2007 - 11:02:12 CST