Re: open_cursors question

From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
To: sbecker6925@xxxxxxxxx
Date: Fri, 28 Jul 2006 22:15:10 -0500

Sandra,

You say this is Java. Is an application server used? If so, the application
server connection settings may have some effect.

Modern O-O applications like this do indeed consume a staggering number of
open cursors. That is just the way it is -- increase OPEN_CURSORS and move
to the next issue.

I have not seen any effect on the database. I suspect the additional cursors
probably consumes some additional memory, but I have no facts.

Dennis Williams

References:

open_cursors question
From: Sandra Becker

Re: open_cursors question

Other related posts: