Re: "direct path write" wait event
Date: Sat, 31 Jan 2009 07:22:58 -0800 (PST)
Message-ID: <f0e1f632-9e87-4fba-a8da-c0977e8c747c_at_o40g2000prn.googlegroups.com>
On Jan 31, 5:10 am, shweta.kapar..._at_googlemail.com wrote:
snip
> No free space in temp.
snip
> Kindly , help how to reduce direct path write waits?
If you run a query that uses up all your temp space it means that something in the query is causing a sort ( order by probably ).
Your best approach in getting the quickest results from a query that uses up all your temp space is the Cary Millsap approach ... just don't do it.
There may be ( probably is ) something wrong with the query ... can it be rewritten? Otherwise you are going to have to perhaps increase your available temp space.
Many people have procedures put in place on OLTP systems ( by various ways ) to stop/prevent/kill sessions that exceed some amount of temp space usage ( more than 1 gig of temp space ... more than 256 meg of temp space ... more than 5 gig of temp space ... opinions vary ). Received on Sat Jan 31 2009 - 09:22:58 CST