Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 3792 invoked from network); 8 Aug 2008 20:38:53 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 8 Aug 2008 20:38:53 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9369A8E3CF1; Fri, 8 Aug 2008 21:38:45 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02619-05; Fri, 8 Aug 2008 21:38:45 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A98098E38D9; Fri, 8 Aug 2008 21:38:43 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 08 Aug 2008 21:36:44 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C9A6E8E3BA3 for ; Fri, 8 Aug 2008 21:36:43 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01592-02 for ; Fri, 8 Aug 2008 21:36:43 -0400 (EDT) Received: from n5.bullet.mail.re4.yahoo.com (n5.bullet.mail.re4.yahoo.com [206.190.56.24]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 981938E3776 for ; Fri, 8 Aug 2008 21:36:42 -0400 (EDT) Received: from [68.142.230.28] by n5.bullet.re4.yahoo.com with NNFMP; 09 Aug 2008 01:36:41 -0000 Received: from [216.252.111.167] by t1.bullet.re2.yahoo.com with NNFMP; 09 Aug 2008 01:36:41 -0000 Received: from [127.0.0.1] by omp102.mail.re3.yahoo.com with NNFMP; 09 Aug 2008 01:36:41 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 556278.90999.bm@omp102.mail.re3.yahoo.com Received: (qmail 674 invoked by uid 60001); 9 Aug 2008 01:36:41 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Reply-To:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=6mrKgQbu3i7vNQJxymvEmlbYZIlp6ZVPsonWBeWSZrK1/P5nbvE7hQ2zIbImxEKaOlgXzJdP9uOM8Vt7kQI0sPCfpzz0yUGK2zV8Pf37RjHJv5L4ufBKanOx//FAmM4Y2JZ+BK5NKi3i3EVchPVtPxfpZsPb8tD4oBvh4jMY64E=; Received: from [69.124.238.241] by web57507.mail.re1.yahoo.com via HTTP; Fri, 08 Aug 2008 18:36:41 PDT Date: Fri, 8 Aug 2008 18:36:41 -0700 (PDT) From: Ajay Thotangare Subject: SQL*Net message from client - But very high CPU To: oracle-l@freelists.org Cc: ajayoraclel@yahoo.com MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1729196097-1218245801=:91077" Message-ID: <445091.91077.qm@web57507.mail.re1.yahoo.com> X-archive-position: 10020 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ajayoraclel@yahoo.com Precedence: normal Reply-to: ajayoraclel@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --0-1729196097-1218245801=:91077 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi List, I need help in solving performance problem of a query. My database is 10.2.= 0.3 on HP-UX Itanium. I traced the session during the run and noticed the session is using very h= igh CPU but the wait event in v$session shows "SQL*Net message from client"= ..=20 In top(UNIX command) this session is the top most. Not able to interpret wh= ats happening. Below is the trace details call=A0=A0=A0=A0 count=A0=A0=A0=A0=A0=A0 cpu=A0=A0=A0 elapsed=A0=A0=A0=A0= =A0=A0 disk=A0=A0=A0=A0=A0 query=A0=A0=A0 current=A0=A0=A0=A0=A0=A0=A0 rows ------- ------=A0 -------- ---------- ---------- ---------- ----------=A0 -= --------- Parse=A0=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=A0=A0 0.00=A0=A0=A0=A0=A0=A0 0.00=A0= =A0=A0=A0=A0=A0=A0=A0=A0 0=A0=A0=A0=A0=A0=A0=A0=A0=A0 0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 0 Execute=A0 13266=A0=A0=A0=A0 25.92=A0=A0=A0=A0=A0 28.85=A0=A0=A0=A0=A0=A0= =A0=A0=A0 0=A0=A0=A0=A0=A0=A0=A0=A0=A0 0=A0=A0=A0=A0=A0=A0=A0=A0=A0 0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 0 Fetch=A0=A0=A0 13267=A0=A0 1768.47=A0=A0=A0 1875.36=A0=A0=A0=A0=A0=A0=A0=A0= 47=A0=A0 67207044=A0=A0=A0=A0=A0=A0=A0=A0=A0 0=A0=A0=A0=A0=A0=A0 23592 ------- ------=A0 -------- ---------- ---------- ---------- ----------=A0 -= --------- total=A0=A0=A0 26534=A0=A0 1794.39=A0=A0=A0 1904.21=A0=A0=A0=A0=A0=A0=A0=A0= 47=A0=A0 67207044=A0=A0=A0=A0=A0=A0=A0=A0=A0 0=A0=A0=A0=A0=A0=A0 23592 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 998=A0=20 Noticed fetch is using 1768.47 CPU of the elapsed time 1875.36. Any help appreciated. --regards, Ajay=0A=0A=0A --0-1729196097-1218245801=:91077 Content-Type: text/html; charset=us-ascii
Hi List,
I need help in solving performance problem of a query. My database is 10.2.0.3 on HP-UX Itanium.
I traced the session during the run and noticed the session is using very high CPU but the wait event in v$session shows "SQL*Net message from client".
In top(UNIX command) this session is the top most. Not able to interpret whats happening.
Below is the trace details
call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute  13266     25.92      28.85          0          0          0           0
Fetch    13267   1768.47    1875.36         47   67207044          0       23592
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    26534   1794.39    1904.21         47   67207044          0       23592
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 998 
Noticed fetch is using 1768.47 CPU of the elapsed time 1875.36.
Any help appreciated.
--regards,
Ajay

--0-1729196097-1218245801=:91077-- -- http://www.freelists.org/webpage/oracle-l