Oracle: ORA-01652: unable to extend temp segment by 256 in ...
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
Those tablespace are DMTT and we running
Oracle 22.214.171.124 on windows 2000 Advanced
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?