Hi,
Or set OPEN_CURSORS=larger value. The initial default
is usually quite small.
Ari S.
----- Original Message -----
From: "Shahar Solomianik" <[EMAIL PROTECTED]>
To: "'jBoss'" <[EMAIL PROTECTED]>
Sent: 20. marraskuuta 2000 12:30
Subject: RE: [jBoss-User] Max open cursors problem using oracle db
> Hi Tilmann.
>
> The max open cursors in Oracle db is a "known" performance issue - Oracle
> actually doesnt close the cursors (even when you call close()) but caches
> them.
> To really close the cursors, you must supply an init parameter in
> initxxx.ora :
>
> CLOSE_CACHED_OPEN_CURSORS = TRUE
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Tilmann Ludwig
> Sent: Monday, November 20, 2000 12:13 PM
> To: 'jboss-user'
> Subject: [jBoss-User] Max open cursors problem using oracle db
>
>
> I'm still getting the max open cursors problem, using an oracle db and
JBOSS
> 2.0 FINAL.
> Is there a way, to configure the caching of prepared statement through
> jboss.jcml (Marc Fleury
> wrote, that this would be possible ind JBOSS FINAL).
>
> Thanx
>
> Tilmann
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
