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: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Fri, 3 Mar 2006 19:58:20 -0600
Message-ID: <de807caa0603031758x4df92b15i5f965f2e2eccafbb@mail.gmail.com>


Hitender,

What version of Oracle? What platform?
What is your init.ora settings?

Dennis

On 3/3/06, hitender chugh <chughhk_at_hotmail.com> wrote:
>
> Runining the SCRIPT:ESTIMATE SHARED POOL UTILIZATION from Note:105004.1of 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 03 2006 - 19:58:20 CST

Original text of this message

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