Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> oracle 9i automatic undo management - space usgae 100%

oracle 9i automatic undo management - space usgae 100%

From: <premmehrotra_at_hotmail.com>
Date: 10 Dec 2004 08:31:34 -0800
Message-ID: <1102696294.329676.141790@f14g2000cwb.googlegroups.com>


I have oracle 9i database on HP UNIX 11i with automatic undo management. I created
undo tablespace to be 1800M. When I look in OEM, storage, it shows undo tablespace as 100% used, but I do not see any errors in alert.log file and any other errors. Is this normal, i.e., is I cause for concern. I have following parameters in "init.ora"

undo_management                      string      AUTO
undo_retention                       integer     604800
undo_suppress_errors                 boolean     FALSE
undo_tablespace                      string      UNDOTBS1

it maybe that I have asked undo_retnetion to be too large, but my unerstanding is that Oracle will ingnore this parameter if there is not enough space anyway?

Thanks,
Prem Received on Fri Dec 10 2004 - 10:31:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US