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

Posted by ErmanArslansOracleBlog on Nov 21, 2024; 10:22am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-01652-unable-to-extend-temp-segment-by-128-in-tablespace-TEMP-tp12753p12762.html

The problematic query seems to be with localizations.. (CLE)
I already told you that you need to concentrate on reducing temp usage. Sorting and complex joins for instance.. These triggers temp usage, and you should tune your query to minimize them..  You may decrease to inputs to those things by reducing the operations that provides the inputs.. For instance if you get lots of data using FTS and then sort them, you will use lots of temporary tablespace.
So, tuning to query is the way, but you have to have 2 perspectives, 1) trying to reduce the sorting operations and unnecessary complex joins, 2) reduce the data to be sorted or joined..
Please have a look with your developer(s)

Note that, if it is a standard query and if it is related with the localization, check oracle support for performance patches of the product CLE.