Database Administration (MOSC)

MOSC Banner

shared_pool parameter setting vs. shared_pool use

edited Jul 9, 2012 3:12AM in Database Administration (MOSC) 8 commentsAnswered
Hello -

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center