Re: Montioring table usage

On 23 Jan, 17:02, "Steve Howard" <stevedhow..._at_gmail.com> wrote:
> 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.
>
> > ThanksYou 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

That's brilliant. Thanks Steve. Received on Wed Jan 24 2007 - 03:33:59 CST