Shared pool utilization more than allocation

  • From: "hitender chugh" <chughhk@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 03 Mar 2006 20:49:42 -0500

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
-- //www.freelists.org/webpage/oracle-l

Other related posts: