Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!news-out2.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!npeer.de.kpn-eurorings.net!npeer-ng1.de.kpn-eurorings.net!feeder1.news.weretis.net!weretis.net!news.solani.org!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: "direct path write" wait event Date: Mon, 2 Feb 2009 10:14:32 +0000 (UTC) Organization: solani.org Lines: 25 Message-ID: References: <067f9762-f65e-4ee6-93ed-7de6c71f9682@i20g2000prf.googlegroups.com> <96426dee-1e31-44e1-a981-ed3f4c7747f4@r15g2000prh.googlegroups.com> <165522d3-7715-4867-99e0-67aabbce3048@w1g2000prk.googlegroups.com> NNTP-Posting-Host: eJwNyUkBwDAIBEBLgSyXHAjgX0I735GrpM+gopCVzanhFmP/g/LibEOLpaMD01jGhsHz3JPigkxm8+Pkj+pp1qg5xwChNR/C3Rls Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org eJwFwYEBwDAEBMCVKM8bJxH2H6F3sNDo9EA4FntdRKfuTdmoOoe1wBPYAGqzLt/ao8v1NG4LJPGIMRN4EuDb7tvEvtm+X65nc4/2V7Z6jkaOkt4MUeEYp9TnZNj7Acf8JqM= X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Mon, 2 Feb 2009 10:14:32 +0000 (UTC) Cancel-Lock: sha1:i2rqSTwz2afe0wfIadtkBnw9KNw= User-Agent: Pan/0.133 (House of Butterflies) Xref: news.cambrium.nl On Sat, 31 Jan 2009 18:22:17 -0800, shweta.kaparwan wrote: > Also we use "dedicated server" : > > SQL> select distinct(server) from v$session; > > SERVER > --------- > DEDICATED Dedicated servers, shared servers and connection pooling (11g) mainly differ by how processes allocate memory and how they are scheduled. This doesn't have much to do with direct disk reads or writes. It is true, however, that with shared servers all I/O is done through SGA. As a matter of fact, switching to shared servers would be a great way of getting yourself rid of the direct I/O. It would not eliminate it, it would just make it buffered and blur the statistics. No performance gain is to be expected, you would learn the error code 4031 very, very well, but there would be no direct I/O. -- http://mgogala.freehostia.com