Finding some idle Tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Finding some idle Tables

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    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!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    no

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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)
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

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

  5. #5
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Quote 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
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  6. #6
    Join Date
    Sep 2006
    Posts
    114
    Quote 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

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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
  •  



Click Here to Expand Forum to Full Width