Oracle: ORA-01652: unable to extend temp segment by 256 in ...
Hi,
Users are getting the following error msg.
Oracle: ORA-01652: unable to extend temp segment by 256 in tablespace TEMP1...
We have a reporting application that is accessed by 3000 users.
Because of that I have created a dedicated TEMP1 tablespace just for the application and another tablespace TEMP for the users.
I received ORA-01652 and I have added datafiles to both tablespaces.
TEMP1 is now up to 8GB
TEMP is now 7 GB.
I also increased the SORT_ARAE_SIZE and SORT_AREA_RETAINED_SIZE to 1048576 and keep coalescing both tablespaces. Their pctincrease is set to 0.and I am STILL
GETTING ORA-01652.
Those tablespace are DMTT and we running
Oracle 8.1.7.4 on windows 2000 Advanced
server.
I think 15GB for total temp tablespace is
way too Big and I feel that I just can't keep adding and adding datafiles. Is there anything you can advise me to do?
Thanks
Last edited by Ablakios; 09-07-2003 at 09:59 PM.
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.