Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01652 Unable to extend temp segment by 128 in tablespace TEMP

Amethyst QinMay 26 2010 — edited Jun 11 2010
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2010
Added on May 26 2010
32 comments
10,170 views