11 Replies Latest reply: Sep 11, 2008 6:51 PM by Jonathan Lewis RSS

    Buffer Waits on undo tablespace


      I am running Oracle Database 10g Enterprise Edition Release

      After creating awr report under the section:

      Tablespace IO Stats
      ordered by IOs (Reads + Writes) desc

      I noticed that I have 32 Buffer Waits for my undo tablespace.

      UNDOTBS Buffer Waits = 32

      Does anybody know how to reduce the buffer waits for my undo tablespace?