-
Hi all,
How do you check for frequently updated tables.
Thanks in advance
leonard905
leonard905
leonard905@yahoo.com
-
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
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|