Re: Measuring wait time for openning a new connection

From: OraPerf (Anjo) <anjo.kolk_at_gmail.com>
Date: 14 Aug 2006 06:13:49 -0700
Message-ID: <1155561229.813647.197020@i42g2000cwa.googlegroups.com>

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.

eyal.yurman_at_gmail.com wrote:
> Hi,
>
> I have an application (perl, using DBI) which opens many connections to
> the database.
>
> Will I see the effect of the connections on the wait events?
> If not, can I measure this effect using the listener?
>
>
> Thanks,
> Eyal Yurman.
Received on Mon Aug 14 2006 - 08:13:49 CDT