can someone with RW passwd in CVS, put this "open cursors" thing in Oracle
howto?
marc
|-----Original Message-----
|From: [EMAIL PROTECTED]
|[mailto:[EMAIL PROTECTED]]On Behalf Of Ari Suutari
|Sent: Monday, November 20, 2000 3:22 AM
|To: jBoss
|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]
|
|
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
