Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
One of application job is failing in our BW system and with below error. As per the discussion with customer, the job runs every two hours and they are getting TEMP space issue average 3-4 times in a month.
Customer is asking to increase the temp tablespace even though the current size is 390Gig.
Mon Jan 16 19:35:42 2017
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Mon Jan 16 19:35:42 2017
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Mon Jan 16 19:38:18 2017
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Do we need to increase the temp space and does it resolve the issue after increasing the size?
Can anyone guide how to diagnose where is the issue?
Thanks,
Amit