Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 9i Slow SQL Performance - EXPERTS apply within

Re: 9i Slow SQL Performance - EXPERTS apply within

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 06 Apr 2006 22:41:05 GMT
Message-Id: <pan.2006.04.06.22.41.10.318968@sbcglobal.net> 





On Wed, 05 Apr 2006 08:21:09 -0700, Johne_uk wrote:



>   SQL*Net message from client                     4        5.90

>  9.70





So, this is your single longest lasting wait event which accounts for
almost a third of the execution time. It is highly unlikely that it is
caused by the execution plan. 


-- 
http://www.mgogala.com


Received on Thu Apr 06 2006 - 17:41:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US