ORA-4031这个出错信息是在client才会出现的。不会记录在alert.log中，但是有的时候会在udump中也会留有一些信息。出现4031的类别有很多种，可以查看 x$ksmsp.ksmchcls 这个列得到。下面提供的是关于和 gv$shared_pool_reserved 这个view相关的Scripts　这两个union的结果在正常情况下应该是一样的。不过有的时候 gv$shared_pool_reserved 报出来的last_failure_size列会不准确，可以用sys登入后run下面的scripts

SQselect '1' x, t.*
from gv$shared_pool_reserved t
union
select '2' x,
p.inst_id,
p.free_space,
p.avg_free_size,
p.free_count,
p.max_free_size,
p.used_size,
p.avg_used_size,
p.used_count,
p.max_used_size,
s.requests,
s.request_misses,
s.last_miss_size,
s.max_miss_size,
s.request_failures,
s.last_failure_size,
s.aborted_request_threshold,
s.aborted_requests,
s.last_aborted_size
from (select avg(x$ksmspr.inst_id) inst_id,
sum(decode(ksmchcls, 'R-free', ksmchsiz, 0)) free_space,
avg(decode(ksmchcls, 'R-free', ksmchsiz, 0)) avg_free_size,
sum(decode(ksmchcls, 'R-free', 1, 0)) free_count,
max(decode(ksmchcls, 'R-free', ksmchsiz, 0)) max_free_size,
sum(decode(ksmchcls, 'R-free', 0, ksmchsiz)) used_size,
avg(decode(ksmchcls, 'R-free', 0, ksmchsiz)) avg_used_size,
sum(decode(ksmchcls, 'R-free', 0, 1)) used_count,
max(decode(ksmchcls, 'R-free', 0, ksmchsiz)) max_used_size
from x$ksmspr
where ksmchcom not like '%reserved sto%') p,
(select sum(kghlurcn) requests,
sum(kghlurmi) request_misses,
max(kghlurmz) last_miss_size,
max(kghlurmx) max_miss_size,
sum(kghlunfu) request_failures,
max(kghlunfs) last_failure_size,
max(kghlumxa) aborted_request_threshold,
sum(kghlumer) aborted_requests,
max(kghlumes) last_aborted_size
from x$kghlu) s