Metrics "Current Open Cursors Count" is at 4294967291
This question may have already been asked in a while. But I'd like to ask it again to confirm if our database is still normal.
As seen in my subject, I have a warning message in our EM informing me that our current open cursor is at this high value: "*4294967291*".
I do not have much information in cursor, all I know is that this is being used by our Applications and other PL/SQL program while they are running.
With this situation, here are my questions:
1. What does this value (4294967291) denotes?
2. With that fetched value (4294967291), is our database still normal?
3. Should there be a need for our application to explicitly close the oracle db cursors?
4. If I set my Open_cursor at that high value, will there be any negative performance hit in the Database?
Our database initialization parameter are set to this value:
open_cursors = 600
session_cached_cursors = 500
Hoping for your most positive response.
Thanks in advance