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