Identify what tables are updated

by Granville Bonyata on October 14, 2016

Sometimes it is necessary to find if there are any cases where a table is updated, such as if you’re considering compressing a table and want to see if there will be an updates that come along after and uncompress the data.

It isn’t perfect, but one handy place to look is in the Plan view:

select object_owner, object_name, COUNT(DISTINCT sql_id)
from dba_hist_sql_plan
WHERE (operation LIKE 'UPDATE%' OR operation LIKE 'MERGE%')
AND object_name = 'Table_name goes here'
GROUP BY object_owner, object_name

Previous post:

Next post: