Hello Gurus,
I apologies posting the same pot in different category
I am getting strange error, after query running for 15 minutes.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_TS
01652. 00000 - "unable to extend temp segment by %s in tablespace %s"
*Cause: Failed to allocate an extent of the required number of blocks for
a temporary segment in the tablespace indicated.
*Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.
select * from v$version;
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
"CORE 11.2.0.3.0 Production"
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 – Production
After following suggestions online I increased TEMP_TS to 10Gig since I got the same error few more times.
I have other database with same data in which I have less temp space (5 Gig) but, it is not throwing error and give results below 1 sec.
I bounce the database see if that makes difference but it did not.
My question is
*1. What other parameters that I need to consider for this error?*
*2. Why even after increase in temp space (almost doubled) did not resolve the error?*