Hi, all.
The db is 11.2.0.3 on a linux machine.
As we know, ddl statements on database objects cause cursror invalidation.
A number of cursor invalidation WITHOUT ddl statements means that shared pool is too small?
The following is a part of AWR report.
Library Hit % is near to 100%, but I can find a number of cursor invalidation from v$sql view.
What could cause cursor invalidation except ddl statements?
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %: 100.00 Redo NoWait %: 99.99
Buffer Hit %: 99.39 In-memory Sort %: 100.00
Library Hit %: 100.02 Soft Parse %: 99.99
Execute to Parse %: 86.93 Latch Hit %: 99.39
Parse CPU to Parse Elapsd %: 91.51 % Non-Parse CPU: 97.42
Thanks in advance.
Best Regards.