Re: SQL*Net message from client waits

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 28 Jun 2007 11:22:52 +0100
Message-ID: <WIqdnUbH3N9lFh7bRVnyiwA@bt.com>

<baba_jaga_at_tahiti.net> wrote in message news:1182973560.318722.20190_at_k29g2000hsd.googlegroups.com...
> Hello
>
> some users complain about a Powercenter performance, I traced the
> sessions for an hour, please have a look at last section of the the
> output of tkprof below. It is a 32 processors Sun running 9.2.0.6, not
> dedicated to this application. Running the trace the box was in avg.
> 30% idle. I checked the plans and they seem to be OK, I know that
> these wait events *may* be idle. Do I have problems with the network
> in your opinion? Has anybody dealt with comparable problems?

For comments, see

http://jonathanlewis.wordpress.com/2007/06/28/tkprof-1/

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Thu Jun 28 2007 - 05:22:52 CDT