Re: SQL*Net message from client - But very high CPU
- From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- To: ajayoraclel@xxxxxxxxx
- Date: Fri, 8 Aug 2008 20:57:57 -0500
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@xxxxxxxxx>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
>
>
Other related posts:
