Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Monitor table usage

user12028662Jun 4 2010 — edited Jun 4 2010

Version 10.2.0.3

We have some tables that we understand were created as backup tables in past. But since it's production we want to ensure that they are not getting used.
Auditing parameter is set to NONE.

I wanted to know if there's anyway we can check usage of these tables by anybody without having to bounce DB.

can alter table monitoring help?

Thanks for your help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 2 2010

Added on Jun 4 2010

#general-database-discussions

7 comments

1,379 views