Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to identify which table get lots of updates.

Beauty_and_dBestMar 26 2016 — edited Dec 8 2017

Hi ALL,

11gR2

OL6.6

How do you find the table which gets most  updates hence generating lots of archivelogs?

Can you share me a sql script for this please?

Kind regards,

jc

This post has been answered by Nikhil Kumar on Mar 26 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2016
Added on Mar 26 2016
30 comments
10,636 views