Skip to Content
0
Former Member
Oct 10, 2014 at 05:43 AM

ORA-1652: Unable to extend temp segment by 128 in tablespace PSAPTEMP

1384 Views

Hi,

I have upgraded to oracle version 11.2.0.4.0 recently. After upgrade I receive "ORA-1652: Unable to extend temp segment by 128 in tablespace PSAPTEMP" everyday in database check log. There is sufficient space for PSAPTEMP and the status of tablespace in RZ20 is green. I have checked with SQL command "select inst_id, tablespace_name, total_blocks, used_blocks, free_blocks from gv$sort_segment" which returns that there are free blocks available upto 3 Gb.

When I checked tablespace status with BRTOOLS, it shows used space is 0%.

Could anyone tell me how to correct this alert message???

Thanks and regards,

Ganesan

Attachments