Home » SQL & PL/SQL » SQL & PL/SQL » Open cursor (11g32 linux(RHEL))
Open cursor [message #667410] Wed, 27 December 2017 02:20 Go to next message
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
Re: Open cursor [message #667413 is a reply to message #667410] Wed, 27 December 2017 02:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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.

Re: Open cursor [message #667419 is a reply to message #667413] Wed, 27 December 2017 06:20 Go to previous message
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)
Previous Topic: Set timestamp with milliseconds to default to 0 milliseconds
Next Topic: over partition by
Goto Forum:
  


Current Time: Fri Mar 29 02:43:22 CDT 2024