ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Posted by janardan_ad on Nov 20, 2024; 4:30pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-01652-unable-to-extend-temp-segment-by-128-in-tablespace-TEMP-tp12753.html

Hi Erman,

We are encountering a strange issue, we have performed recently cross platform migration from On Prem Unix platform to Linux platform, post that we are observing an error with custom concurrent program where its failing due to temp error.

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

The same program in the previously done iteration completing within seconds but in the 2nd iteration instance its running for 20 min and then failing, as of now the temp size is around 150 GB, still the concurrent request is filing with same temp error , log file is attached.