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: Oracle needs to be restarted to accept new connections

Re: Oracle needs to be restarted to accept new connections

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 01 Nov 2005 14:22:07 GMT
Message-Id: <pan.2005.11.01.14.22.07.732308@sbcglobal.net>


On Tue, 01 Nov 2005 05:55:31 -0800, DavidDublin wrote:

> The network connection is slow when connecting with sqlplus on the same
> machine.

Did you take a look into V$SYSTEM_EVENTS or V$SESSION_WAIT? That might tell you what are you waiting for? What does top say? Are you spinning or idly waiting?

-- 
http://www.mgogala.com
Received on Tue Nov 01 2005 - 08:22:07 CST

Original text of this message

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