Re: Measuring wait time for openning a new connection

On Mon, 14 Aug 2006 06:13:49 -0700, OraPerf (Anjo) wrote:

> 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.

There is no need to do it in a complicated way, Perl allows you to do it an easy way.

-- 
http://www.mgogala.com