Re: open_cursors question

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Fri, 28 Jul 2006 22:15:10 -0500
Message-ID: <de807caa0607282015x47e990d0y4b8ea4959ff58b@mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 28 2006 - 22:15:10 CDT