ORA-1652: unable to extend temp segment
Our SAP CRM 5.0 system having a database size of 110 GB, running in Oracle 10g, AIX platform.
We are having frequent "ORA-1652: unable to extend temp segment" error in our alert log.
The temp tablespace PSAPTEMP is 21GB in size.
The largest index is 1.5 GB in size.
We have 4 temp datafiles which consumes the same size on disk (not sparse file).
Could you please help to check whether:
1. the current size of PSAPTEMP (21 GB) is enough or not
2. is the temp tablespace really used up or not.
3. "how" this will adversly effect the performance of the system.
Thanks in advance !