Home » RDBMS Server » Server Administration » Metrics "Current Open Cursors Count" is at 7057
Metrics "Current Open Cursors Count" is at 7057 [message #218439] Thu, 08 February 2007 03:55 Go to next message
Shekhar_Mohol
Messages: 2
Registered: February 2007
Location: PUNE
Junior Member
Hi,

Above Database Limit alert display in Oracle Enterprise Manager.

The detail alert is as per following ...

Feb 8, 2007 1:31:10 PM Metrics "Current Open Cursors Count" is at 7057
Feb 8, 2007 1:26:09 PM Metrics "Current Open Cursors Count" is at 5228
Feb 8, 2007 10:15:21 AM Metrics "Current Open Cursors Count" is at 2246
Feb 8, 2007 9:58:17 AM Metrics "Current Open Cursors Count" is at 782
Feb 8, 2007 8:44:58 AM Metrics "Current Open Cursors Count" is at 1328
Feb 7, 2007 9:05:33 PM Metrics "Current Open Cursors Count" is at 529
Feb 7, 2007 8:16:34 AM Metrics "Current Open Cursors Count" is at 1257 [/FONT]

The value of open_cursor parameter is 7500.

If we check count(*) from v$open_cusror
The following output display at variour time gaps.

16390
16255
16251
17090
16799
16801
16818
16820
16852
16855
16854
16877
16996

and so. on.

DO YOU FEEL THAT I SHOULD INCRESE THE VALUE OF OPEN_CURSOR PARAMETER IN INIT.ORA FILE ...
I HAVE 160 CON-CURRENT USER FOR BAAN APPLICATION ..

Thanks and Regards

Shekhar Mohol
shekhar.mohol@thermaxindia.com




Re: Metrics "Current Open Cursors Count" is at 7057 [message #218634 is a reply to message #218439] Fri, 09 February 2007 01:45 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Most definitely yes:

"It is important to set the value of OPEN_CURSORS high enough to prevent your application from running out of open cursors. The number will vary from one application to another. Assuming that a session does not open the number of cursors specified by OPEN_CURSORS, there is no added overhead to setting this value higher than actually needed."

Source: Database Reference Guide.
Previous Topic: Oracle 10g Installation Process - Error on running ./runInstaller
Next Topic: Segment advisor problem
Goto Forum:
  


Current Time: Sun Dec 11 08:08:23 CST 2016

Total time taken to generate the page: 0.15618 seconds