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: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 14 Aug 2006 08:48:30 -0700
Message-ID: <1155570511.496580@bubbleator.drizzle.com>


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 - 10:48:30 CDT

Original text of this message

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