Had a query which took ages. After checking the session browser I noticed the query was doing a lot of “direct path write temp”. So I checked directly the sort_area_size. Big surprise it had a value of 64K!!!
After sending a mail to the DBA’s of my current project to ask to increase to 1GB, everything went smooth.

This entry was posted on Tuesday, December 23rd, 2008 @ 4:08 pm on the category Oracle 10g. You can follow any responses to this entry through the RSS 2.0 You can leave a response, or trackback from your own site.