Re: open cursors for Oracle Forms application sessions
- From: Neil Kodner <nkodner@xxxxxxxxx>
- To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- Date: Sat, 3 Apr 2010 09:06:14 -0400
Problem is that because of unemployment and the economy, our user base has
expanded beyond our wildest expectations(set about 8 years ago based on 20
years of historical data). We've had to ramp up the number of desktops
using our app and are having trouble keeping up with the demand for PGA.
Its not uncommon for our 32GB box to have only about 500mb ram left and be
swapping 30GB.
Our forms sessions typically use about 20-25MB each. Our delphi, c# and
java sessions seem to want much less PGA. I'm doing what I can to relieve
the strain placed on the box, and all of the swapping due to our RAM being
pegged all of the time.
On Fri, Apr 2, 2010 at 10:19 AM, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx
> wrote:
> Neil,
>
> The number of cursors that Oracle Forms needs has historically always
> been high. It is not uncommon to see open_cursors in a forms db set to 600
> or better. No your not doing anything wrong, and neither are the
> developers. It's just a forms thing.
>
>
> *Dick Goulet***
> Senior Oracle DBA/NA Team Lead
> PAREXEL International
>
>
> ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Neil Kodner
> *Sent:* Thursday, April 01, 2010 10:02 AM
> *To:* Neil Kodner; oracle-l-freelists
> *Subject:* open cursors for Oracle Forms application sessions
>
> I support a database which is used by about 6 applications, one of which is
> an Oracle Forms application. The sessions coming from Oracle Forms always
> use far more PGA than the rest of the sessions (java, .net, c#, etc). I'm
> looking at open cursor counts across my instance and see that the forms
> sessions constantly have upwards of 200 cursors open at any one time,
> compared to the java, delphi, and others, which seem to do a good job
> closing them.
>
> Not knowing much about Oracle forms, is there anything I could be doing, or
> suggesting to the developers/forms admin to get Forms to handle the cursors
> better?
>
Other related posts:
