How can I tell if my UNDO tablespace is large enough?
If you run out of UNDO you will get the message “ORA-30036: unable to extend segment by 8192 in undo tablespace ‘UNDOTBS'” and the update will abort. The size of your UNDO is governed by the total space required to store the before images for your largest DML transaction. The size of your UNDO is governed by the total space required to store the before images for your largest DML transaction. Some DBA’s use the “autoextend” option on their UNDO tablespace, but you run the risk of running out of disk space if you have a super-large update running, or a runaway update. Like everything it Oracle, the choice us using qutoextend for UNDO depends on your system requirements. If your SLA requires you to minimize aborts, it might be worth the risk of filling-up a disk. >> Is it better to increase the Oracle datafile size or add another datafile to increase the Oracle tablespace size? Some DBA’s choose to add datafiles instead of using autoextend for the tablespace. The choice of adding datafil