Skip to content

Instantly share code, notes, and snippets.

@dotmaik1

dotmaik1/resports: table transaction report.sql

Created October 6, 2016 17:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dotmaik1/f3a3d3ace0db2e2c90089db6499c160e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dotmaik1/f3a3d3ace0db2e2c90089db6499c160e to your computer and use it in GitHub Desktop.
Download ZIP
table transaction report Instant DBA
Raw
resports: table transaction report.sql
set lines 200
SELECT TABLE_OWNER,
TABLE_NAME,
INSERTS,
UPDATES,
DELETES,
TO_CHAR(TIMESTAMP,'DD-MON-YY HH24:MI:SS') TIMESTAMP,
TRUNCATED,
DROP_SEGMENTS
FROM ALL_TAB_MODIFICATIONS
order by INSERTS desc,
UPDATES desc,
DELETES desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment