---查看shared_pool使用情況?
column shared_pool_used format 9,999.99
column shared_pool_size format 9,999.99
column shared_pool_avail format 9,999.99
column shared_pool_pct format 999.99

select
?????? shared_pool_used,
?????? (shared_pool_used/shared_pool_size)*100? Shared_pool_per,
?????? shared_pool_size,
?????? (shared_pool_size-shared_pool_used) shared_pool_avail from
(
select
? sum(a.bytes)/(1024*1024) shared_pool_used
? from v$sgastat a
where a.name in
? ( 'table definiti',
? 'dictionary cache',
? 'library cache',
? 'sql area',
? 'PL/SQL DIANA')
),
(
select
? sum(b.bytes)/(1024*1024) shared_pool_size
from v$sgastat b
where pool='shared pool'
);?

轉(zhuǎn)載于:https://blog.51cto.com/yeluyide/1136771

總結(jié)

以上是生活随笔為你收集整理的查询shared_pool主要部分的使用率的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。