-
Finding some idle Tables
Dear All,
I want to know some idle tables in some of my production Schema
For Example
i want to search those tables on which no activity (select,insert,update,delete) for the last 2-months.
Auditing is available for this task but i don't have auditing enabled ,is there any other option except auditing ?
Please suggest!
-
-
Might he not be able to use LogMiner in some fashion? (assuming he has all the logs from the past two months and is at 9i or higher)
-
That would cover insert / update / deletes, but not selects. Other than auditing, there is no record of who selected what when from where.
-
Originally Posted by jhmartin
That would cover insert / update / deletes, but not selects. Other than auditing, there is no record of who selected what when from where.
Dang - knew I was missing something
-
Originally Posted by chrisrlong
Might he not be able to use LogMiner in some fashion? (assuming he has all the logs from the past two months and is at 9i or higher)
Although i have very limited knowledge abt Logminer ,can u please tell me how to user Logminer to accomplish my requirements?
I'll thankful to u
-
it doesnt accomplish all your requirements
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|