SQL> select * from v$sysstat a where a.STATISTIC#=339;
STATISTIC# NAME CLASS VALUE STAT_ID
---------- ---------------------------------------------------------------- ---------- ---------- ----------
339 parse count (hard) 64 12614 143509059
SQL> select namespace,gets,pins,reloads,INVALIDATIONS from v$librarycache;
NAMESPACE GETS PINS RELOADS INVALIDATIONS
-------------------- ---------- ---------- ---------- -------------
SQL AREA 953706920 953785272 8674 943
TABLE/PROCEDURE 17373 145986 2048 0
BODY 178 2072 29 0
TRIGGER 302 436 85 0
INDEX 208 472 5 0
CLUSTER 715 2419 5 0
OBJECT 0 0 0
DDL引发的对象invalidation
最新推荐文章于 2021-04-12 04:38:37 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)