shared_pool parameter setting vs. shared_pool use
I run the following query:
SELECT TO_CHAR(SYSDATE,'mm/dd/yyyy hh24:mi:ss') TIME_NOW,'SDP5' WHICH_DB,G1.* FROM GV$PARAMETER G1 WHERE REGEXP_LIKE(NAME,'shared','i')
I get these results:
"NAME" "DISPLAY_VALUE"
"shared_memory_address" "0"
"hi_shared_memory_address" "0"
"shared_pool_size" "200M"
"shared_pool_reserved_size" "10M"
"shared_servers" "0"
"max_shared_servers" ""
"shared_server_sessions" ""
I note that my shared_pool parameter setting is 200M.
I run the following query:
select round(sum(bytes)/1024/1024) || 'M' in_use_currently from v$sgastat where pool='shared pool'
"IN_USE_CURRENTLY"
"204M"
I note that current shared_pool use is 204M.