Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-1652: unable to extend temp segment

Dear Gurus,

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 !



Former Member
Not what you were looking for? View more on this topic or Ask a question