Finding some idle Tables

[M.Shakeel Azeem]

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!

[davey23uk]

no

[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)

[jhmartin]

That would cover insert / update / deletes, but not selects. Other than auditing, there is no record of who selected what when from where.

[chrisrlong]

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

[M.Shakeel Azeem]

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

[davey23uk]

it doesnt accomplish all your requirements