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: Measuring wait time for openning a new connection

Re: Measuring wait time for openning a new connection

From: OraPerf (Anjo) <anjo.kolk_at_gmail.com>
Date: 14 Aug 2006 10:12:48 -0700
Message-ID: <1155575568.330077.327330@p79g2000cwp.googlegroups.com>


Thank you Daniel.

DA Morgan wrote:
> OraPerf (Anjo) wrote:
> > Hi Eyal,
> >
> > What would you be looking for? The fact that you start many connections
> > is a bad thing. Probaby what you do is start a connection, do some work
> > and disconnect. This will cause all open cursors for the session to be
> > closed again and they need to be opened. This overhead isn't measured
> > in any wait event in particular, but in many events. In oracle10g there
> > is some measurements done on the logon/logoff time, so you can see the
> > overhead there.
> >
> > Anjo.
>
> Welcome. Good to see you here.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Mon Aug 14 2006 - 12:12:48 CDT

Original text of this message

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