Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Shared pool utilization more than allocation

Shared pool utilization more than allocation

From: hitender chugh <chughhk_at_hotmail.com>
Date: Fri, 03 Mar 2006 20:49:42 -0500
Message-ID: <BAY105-F33C2EEC7231E097CFB692DBDEB0@phx.gbl>

Runining the SCRIPT:ESTIMATE SHARED POOL UTILIZATION from Note:105004.1 of metalink shows Shared pool utilization more than allocation and shows free memory as 31.5Mb as shown below . Why this discrepancy? Can somebody explain please?
 
 
Object mem:    466190256 bytes
Cursors:       113500 bytes
Free memory:   33082336 bytes (31.55MB)
Shared pool utilization (total):  606194883 bytes (578.11MB)
Shared pool allocation (actual):  536870912bytes (512MB)
Percentage Utilized:  113%
 
Thanks
-- http://www.freelists.org/webpage/oracle-l Received on Fri Mar 03 2006 - 19:49:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US