Raising the Max open cursors may not be solving the real problem. Check your code and make sure you are closing the prepared statements that you are using. If you do ot do this and then close the connection you leave reasources open on the Oracle server. Also, you shouldn't reuse a prepared statement again until after you have closed it first. In a connection pooled environment, not closing the connections resources before calling close on the connection leaves the resources open on the db server because technically the connection is not closed just returned to the pool.
John Kidd
| "Ari Suutari" <[EMAIL PROTECTED]>
Sent by: <[EMAIL PROTECTED]> 11/20/2000 05:22 AM
|
To: "jBoss" <[EMAIL PROTECTED]> cc: Subject: Re: [jBoss-User] Max open cursors problem using oracle db |
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]
