Skip to content

Instantly share code, notes, and snippets.

@dincosman

dincosman/most_invalidated_sql.sql

Created August 12, 2024 20:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dincosman/630a01ae2eb211085a23e75062881722 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dincosman/630a01ae2eb211085a23e75062881722 to your computer and use it in GitHub Desktop.
Download ZIP
Most Invalidated Sql statements
Raw
most_invalidated_sql.sql
SQL> SELECT sql_id,
sum(invalidations)
FROM gv$sql
WHERE invalidations > 0
GROUP BY sql_id
ORDER BY sum(invalidations) desc
FETCH first 20 ROWS only ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment