Hi
Oracle 12.1.0.2.0
Is it possible to reset cached cursors for specific session..?
Problem is probably because of this bug:
Bug 21135007 - Value of statistic "session cursor cache count" exceeds value of database parameter session_cached_cursors (Doc ID 21135007.8)
I will apply this patch as soon as possible, but I was just wondering perhaps there is a way to reset this for specific session.
In node 1 there is this oracle background session oracle@XXXXX (QM03) with value 100+k (basically with 3 days of running database, the value is 100+k)
Or perhaps I can just kill this process and nothing bad happens..? (production database)
I am worried because I found out, that cached session cursors are held in shared_pool, and these huge cached cursors could potentially thrash my shared pool, am I right..?
Regards
Raul