Re: open_cursor count keeps growing
From: Moe <mwahidi_at_emanagelaw.com>
Date: 14 Sep 2005 20:37:28 -0700
Message-ID: <1126755448.841850.173370_at_z14g2000cwz.googlegroups.com>
Date: 14 Sep 2005 20:37:28 -0700
Message-ID: <1126755448.841850.173370_at_z14g2000cwz.googlegroups.com>
[Quoted] A developer at my company. I believe he is missing to close the cursors
somewhere.
is oracle supposed to take care of that automatically or the
application should close it?.
I know that i can flush shared_pool but open_cursor are located in the
PGA, is that correct?
Is it possible to flush the PGA instead of restarting the database
untill we figure out the problem with the application?
Moe Received on Thu Sep 15 2005 - 05:37:28 CEST