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

    Buffer Waits on undo tablespace

    537177
      Hi,

      I am running Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

      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?

      Thanks!