Re: Question about detecting queries

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