Currently in Performance Analysis for Oracle (PAO), there is no information on UNDO consumption or Rollback Segment (RBS) Usage. It would be ideal if PAO could capture UNDO information since DBAs like to use PA as a tool to investigate incidents that is occurring on their databases. The information being captured should include the identity of the users that are utilizing the UNDO tablespace and the transactions they are running. Also if the transaction has completed successfully or rollback in the event of an error (eg. ORA-01555 snapshot too old).
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy