Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> oracle 9i automatic undo management - space usgae 100%
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
![]() |
![]() |