Re: "direct path write" wait event
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 1 Feb 2009 16:37:00 +0000 (UTC)
Message-ID: <gm4j3b$4no$9_at_solani.org>
On Sat, 31 Jan 2009 02:10:27 -0800, shweta.kaparwan wrote:
Date: Sun, 1 Feb 2009 16:37:00 +0000 (UTC)
Message-ID: <gm4j3b$4no$9_at_solani.org>
On Sat, 31 Jan 2009 02:10:27 -0800, shweta.kaparwan wrote:
> Kindly , help how to reduce direct path write waits?
>
> Regards
>
> Shweta
That's simple: rewrite your SQL to avoid unnecessary sorting. For the sorting that is necessary, make sure your hardware and the devoted resources (memory, disk) is up to the task.
-- http://mgogala.freehostia.comReceived on Sun Feb 01 2009 - 10:37:00 CST