Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about detecting queries
DA Morgan wrote:
> ExecMan wrote:
> > Hi,
> >
> > We have a real poorly put together database. It has over 900 tables
> > and over 20 schemas. I want to start to get rid of everything that is
> > not needed and merge the schemas into one.
> >
> > One thing I need to know is which tables are used and which are not.
> >
> > Is there a way to detect when a query is done to a table? This will
> > tell me if the table is used or not........
> >
> > Thanks!
>
> Depends on the version which you don't mention.
>
> In addition to auditing also consider:
>
> ALTER INDEX <index_name> MONITORING USAGE;
>
> Followed later by:
>
> SELECT * FROM v$object_usage;
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Aw comon guys. Nobody mentioned straight slash and burn? (back up table by table, then delete from the DB one table at a time. If nobody screams, then it was safe to delete) It is so fun and exciting, especially for tables used only for the annual audit!
I'm kidding about the method EXCEPT about the part of backing up all data before anything gets deleted. Remember, safety first!
Ed Received on Tue Jan 23 2007 - 12:03:39 CST