SQL & PL/SQL

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!

getting wait event "direct path write temp" during query execution

Suddhasatwa_BhaumikNov 8 2012 — edited Nov 15 2012

Hi All,

While executing one query in database, it is taking longer time and failing with error "ORA-01652: unable to extend temp segment by 1280 in tablespace PSTEMP".

I have increaesd the Temp tablespace size also till 96GB, Database size is 120GB.

I have upgraded the database from 10.2.0.3 to 11.2.0.3 version last month.

same query is running fine in other databases on same version.

It is giving me "Direct write temp path" wait event.

server load is also normal.

I have increased pga_aggregate_target upto 512MB but it has not solved my problem

Can you please help me out to solve this issue.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2012

Added on Nov 8 2012

10 comments

979 views