This content has been marked as final. Show 2 replies
Shaik wrote:Do you see any errors in the database log file (like ORA-30036 Unable To Extend Undo Tablespace)? If not, then there is nothing you need to do.
We have R12.1 Instance with RDBMS 126.96.36.199.0.
Here undo table space is got filled up to 95% , all data files are not in AUTOEXTEND.
In this case i need to add a data file?
If i dint add a data file, is database performance will be poor?
Troubleshooting ORA-30036 - Unable To Extend Undo Tablespace [ID 460481.1]
Automatic Tuning of Undo_retention Causes Space Problems [ID 420525.1]