ORA-01652 Unable to extend temp segment by 128 in tablespace TEMP
Hi All,
For this error I did some investigation. There may be two solutions:
1. Increase size of the temp tablespace
2. Increase sort_area_size and/or pga_aggregate_target
My question if the tablespace TEMP is big enough, and this error is still occuring, how could the setting of ortarea_sie and pga_aggregate_target affect database? In which scenarioes and how?_+
Like my example is the running of 3 database processes in parellel, two got failed, one got stuck after running for 25 min. The
The whole database is 3GB and the TEMP is 8GB.
What does sort_area_size and/or pga_aggrefate_target affect in this case?
Thank you!