Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Net message from client waits
<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.htmlReceived on Thu Jun 28 2007 - 05:22:52 CDT