This content has been marked as final. Show 4 replies
Please see the following docs.
Full UNDO Tablespace In 10gR2 [ID 413732.1]
How to Manage Problem of UNDO Tablespace Reaching 100% of its Capacity [ID 1335964.1]
Troubleshooting ORA-30036 - Unable To Extend Undo Tablespace [ID 460481.1]
Automatic Tuning of Undo_retention Causes Space Problems [ID 420525.1]
If you don't see any ORA-XXXXX errors in the database log file (especially ORA-01555) then you should be fine and there is nothing else to do.
arizuddin wrote:AFAIK since 10gR2 onwards, undo tablespace will always be full what ever size it may be .
Our Production ERP single node instance (Apps: 12.0.6,DB: 10.2.0.3 & OS: AIX 5.3.7) is running since 4 (almost) years. The database was behaving perfectly. Since last week i am observing that 'apps_undots1' is growing rapidly. It has 2 datafiles of size 7Gb each. Day before yesterday, i have added one datafile of 7GB but today it shows as full. What causing the apps_undots1 to grow so rapidly? What precaution to be taken?
MOS Doc 413732.1 - Full UNDO Tablespace In 10gR2
this is normal behavior.
Correct me if Im wrong
Do you see any error in the alert log file ?
Sharing is Caring