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

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

RE: Shared pool utilization more than allocation

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 3 Mar 2006 21:05:23 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF27070BD719@AABO-EXCHANGE02.bos.il.pqe>


Well, first off, unless you're still on Oracle 8.0.x, you're using the wrong script. See Doc ID 105813.1 for the right one.  

Second, Steve Adams makes a couple of points about why it is "only marginally valid" here: http://www.ixora.com.au/q+a/pool.htm#24_10_1999 <http://www.ixora.com.au/q+a/pool.htm#24_10_1999> though it looks like this script has corrected at least one of the problems (duplication of cursors in V$DB_OBJECT_CACHE and V$SQLAREA.  

Hope that helps,  

-Mark

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

"Exception: Some dividends may be reported as qualified dividends but are not qualified dividends. These include:

  --IRS, Form 1040-A Instruction Booklet, Line 9b: Qualified Dividends  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of hitender chugh Sent: Friday, March 03, 2006 8:50 PM
To: oracle-l_at_freelists.org
Subject: Shared pool utilization more than allocation

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 - 20:05:23 CST

Original text of this message

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