Re: SQL*Net message from client - But very high CPU

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Fri, 8 Aug 2008 20:57:57 -0500
Message-ID: <e9569ef30808081857u61261c89q4d91afdbb3b9d437@mail.gmail.com>


Looks like you are peforming a full table scan of a rather large table. 67,207,044 rows. I'd start looking there.

Bradd Piontek
Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd

On Fri, Aug 8, 2008 at 8:36 PM, Ajay Thotangare <ajayoraclel_at_yahoo.com>wrote:

> 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:57:57 CDT

Original text of this message