about shared pool

select a.ksppinm , b.ksppstvl from x$ksppi a , x$ksppcv b  where a.indx=b.indx and a.ksppinm like '%dsidx_count'

_kghdsidx_count 参数决定了share pool 的sub pool的个数

多用v$sqlstats 而不是v$sql 因为代价更小

In view v$librarycache  loads = pin -pinhits  

避免4031错误：

1）shared_pool_reserved_size

2）pin object in memory