check frequently updated tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: check frequently updated tables

  1. #1
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    Hi all,
    How do you check for frequently updated tables.

    Thanks in advance
    leonard905
    leonard905
    leonard905@yahoo.com

  2. #2
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi,

    I am also looking for some script which shows activities in all tables/objects in a specific time frame.

    Example: Betw 2:00 PM to 3:00 PM, which are the tables in which DML (Inserts/updates/Deletes) have been made. Also if possible, in terms of number of blocks/extents increased.

    Thanks,

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  3. #3
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    You can set auditing to track updates or write a trigger that will track select activities. You can even set it to track only during specific time frames.

    If you want to see data growth over time, you can save table stats from DBA_TABLES to a separate table at beginning of time frame. At end of time frame, analyze tables and compare stats.


  4. #4
    Join Date
    Jul 2000
    Posts
    521
    LogMiner can help you in this regard.

    Good part of LogMiner is, once you create the dictionary of your databse, all the analysis can be done on a different database, different server - independant of the production server.
    svk

  5. #5
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Is there any script still to check block level changes in the table?

    Thanks,


    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

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