Skip to Main Content

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!

Identifying the actively used tables

myCloudFeb 19 2016 — edited Feb 23 2016

Is there a way to find if a table is being used actively or sitting in the database with no activity happening for a long time. For ex , we create back-up tables before applying data fixes and they would exist in database for a very long time. We are looking for a way to identify some of the tables which are not actively used for a specific time duration (may be 5-6 years) and get rid off those objects from the database.

This post has been answered by unknown-951199 on Feb 19 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2016
Added on Feb 19 2016
18 comments
5,116 views