SQL*Net message from client - But very high CPU

From: Ajay Thotangare <ajayoraclel_at_yahoo.com>
Date: Fri, 8 Aug 2008 18:36:41 -0700 (PDT)
Message-ID: <445091.91077.qm@web57507.mail.re1.yahoo.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 08 2008 - 20:36:41 CDT