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

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

Thanks Erman, actually we exported plan from an instance where its working fine and imported into the problematic instance post which the program is completing as expected.

Generally, is this recommended method to enhance performance or what's the criteria of steps to be performed as part of troubleshooting performance issue.
Generally, I follow below criteria.

- Gather stats
- Tuning SQL query
- Tuning analyzer recommendations (Like index creation etc)
- And final resort of exporting and importing the plan.

Could you confirm me if this holds to be an effective approach in addressing performance issues.