Skip to content

Instantly share code, notes, and snippets.

@Haruki

Haruki/oracle_undo_use.txt

Created July 11, 2017 08:13
Show Gist options
  • Save Haruki/f21f48a5853878bf194dccbfbecbdbc1 to your computer and use it in GitHub Desktop.
Save Haruki/f21f48a5853878bf194dccbfbecbdbc1 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle use of undo tablespace (Active extents)
Raw
oracle_undo_use.txt
select count(segment_name),sum(bytes/1024/1024),status from dba_undo_extents group by status;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment