unable to extend segment by 1024 in undo tablespace 'UNDOTS
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
We have 4 million bib records. We are getting the following errors in running indexing jobs:
Oracle error: io_z103_write
ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTS
40041 READING DOC 003940040 AT 04:02:17
I resized the UNDOTS1 tablespace to 2G while the jobs are running. It is now using approximately 78 percent of the UNDOTS1, and it is growing. We're running p_manage_12 and p_cir_25 right now.
Is the UDOTS sized correctly? And do I need to increase the undo retention from 10800 to ??
Resolution:
Yes, with your size of database and the amount of ADM, you should increase the UNDO TS. Please double its size to 4GB.
You should not need to increase undo retention.
- Article last edited: 10/8/2013