From oracle-l-bounce@freelists.org Fri Sep 24 09:08:37 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8OE8bA22206 for ; Fri, 24 Sep 2004 09:08:37 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i8OE8YI22197 for ; Fri, 24 Sep 2004 09:08:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A50A372F043; Fri, 24 Sep 2004 09:14:35 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06811-61; Fri, 24 Sep 2004 09:14:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D80DF72DFA1; Fri, 24 Sep 2004 09:12:40 -0500 (EST) In-Reply-To: <962cf44b04092407024e3c2f85@mail.gmail.com> To: zhu chao Cc: oracle-l@freelists.org Subject: Re: Can I tryst in "physical ... direct" figures? MIME-Version: 1.0 Message-ID: From: J.Velikanovs@alise.lv Date: Fri, 24 Sep 2004 17:06:30 +0300 X-MIMETrack: Serialize by Router on ROSS/IT ALISE/LV(Release 5.0.11 |July 24, 2002) at 2004.09.24 17:06:31, Serialize complete at 2004.09.24 17:06:31 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 10078 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: J.Velikanovs@alise.lv Precedence: normal Reply-To: J.Velikanovs@alise.lv X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Thank you for ideas. It is OLTP 200 users system. I have found that very popular SQL use HASH operation :) The reason ir HASH not SORTs Thank you all, Jurijs +371 9268222 (+2 GMT) ============================================ Thank you for teaching me. http://otn.oracle.com/ocm/jvelikanovs.html zhu chao 24.09.2004 17:02 Please respond to zhu chao To: "j.velikanovs@alise.lv" cc: oracle-l@freelists.org Subject: Re: Can I tryst in "physical ... direct" figures? Cound you use the following SQL to find out which session does most of the write? As you mentioned you run ad-hoc query and it is like a datawarehouse, so physical reads direct can be explained via the parallel slave process doing the direct path read, and possibly the direct path write can be done via the sqlldr direct path write? and create table as select? maybe you can use sql like the following one to find out which session does most of the direct path write(if the session hasn't logout, or you are using middleware). set line 200 select b.sid,a.name,b.value from v$sesstat b, v$statname a where a.statistic#=b.statistic# and (a.name like '%physical writes direct%' or a.name like 'physical writes') and b.value>0 order by b.value asc / ----- Original Message ----- From: j.velikanovs@alise.lv Date: Fri, 24 Sep 2004 16:14:53 +0300 Subject: Re: Can I tryst in "physical ... direct" figures? To: zhu chao Hi Zhu, Thanks for respnce. With reads it can be as you described. At the mopment I thought more about writes. How Direct writes cant be 98% of all writes if there olmost no sorts in the system, i wonder? Jurijs +371 9268222 (+2 GMT) ============================================ Thank you for teaching me. http://otn.oracle.com/ocm/jvelikanovs.html zhu chao 24.09.2004 15:36 Please respond to zhu chao To: j.velikanovs@alise.lv cc: Subject: Re: Can I tryst in "physical ... direct" figures? Hi , Since disk sort is very few times, maybe it is "parallel server direct path read", since there isn't parallel_max_servers specified in your spfile, the default value is 4. So, it is possible you are using parallel slave server to do direct path read. -- Regards Zhu Chao www.cnoug.org -- Regards Zhu Chao www.cnoug.org -- http://www.freelists.org/webpage/oracle-l