OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Open cursor (11g32 linux(RHEL))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Open cursor [message #667410]

Wed, 27 December 2017 02:20

dba4oracle
Messages: 100
Registered: June 2010

Senior Member

Hi Guys,

11g32 linux(RHEL)

One of prod db ,open cursor utilization went above 90%,same time saved session details found
one of session opened more than 1000 cursors (utilizing 70% of cursors) and this session is executing same only 1 query
this query is called from java client

its is simple query as - select sysdate from dual;
please share your views in finding why this 1 session executing query have opened 1000 cursors and brought utilization above 90%

(in this case problem session,program/query is known)

Thanks

Report message to a moderator

Re: Open cursor [message #667413 is a reply to message #667410]

Wed, 27 December 2017 02:53

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The answer is simple: the application parse the statement each time it wants to execute it.
The solution is simple: modify the code to parse only once the statement.

Report message to a moderator

Re: Open cursor [message #667419 is a reply to message #667413]

Wed, 27 December 2017 06:20

dba4oracle
Messages: 100
Registered: June 2010

Senior Member

thanks

is any query to check/make report, 2 days back how many cursor each session in db instance has opened (history of open cursor utilization)

Report message to a moderator

Previous Topic:	Set timestamp with milliseconds to default to 0 milliseconds
Next Topic:	over partition by

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 24 11:14:27 CDT 2023