Re: Open Cursor

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Wed, 04 Nov 1998 17:25:50 +0100
Message-ID: <3640800E.305FFA99@psi.de>

With the tool Hora 3 you can monitor the open Cursors of a selected user on the Hora session page. I hope it helps. See ftp:\\www.keeptool.com for a free trial version of Hora 3.

regards Jan Dieckmann

M Indra Bangsawan wrote:

> Dear sir,
>
> my server is using oracle 7.3.2 on nt 3.51. In its initial parameters,
> the open cursor value is 50. When i looked at the detail on session, the sum
> of open cursor from all users is 107.
> Is it affecting the performance of my user transactions ?
> I'm going to raise the open cursor parameter to 64.
> Any comments would be helpful !
> Thanks.
Received on Wed Nov 04 1998 - 10:25:50 CST