Oracle学习之内存块组成结构及4031错误分析

shared pool内存块组成结构:(library cath,free,row cath)

chain:

chunk:

4031:(硬解析大量存在时会产生)

select count(*) from x$ksmsp; --查看chunk

select count(*) from dba_objects;

alter system flush shared_pool;  --将libarary cash 和row cath清空

posted @ 2016-01-04 07:58  道心不可练  阅读(185)  评论(0编辑  收藏  举报