Hello,
We are running Oracle11g (11.2.0.3) on Solaris (SPARC) 11.1
This is standalone DB not part of RAC.
This is fairly busy and large database. We have noticed following warning
-----
SYSTEM ; Warning Metrics Current Open Cursors Count is at 12021
Suggestion: Run ADDM to get more performan
-----
After searching online, we increased the limit couple of times and each time the count goes up and remains there.
Also read an article that flushing the cache would reset, but will cause slight performance hit.
Trying to find solution to this warning.
Thank you,