| Metrics "Current Open Cursors Count" is at 7057 [message #218439] |
Thu, 08 February 2007 03:55  |
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  |
Frank Naude
Messages: 4580
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
