Re: Shared pool utilization more than allocation

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: chughhk@xxxxxxxxxxx
  • Date: Fri, 3 Mar 2006 19:58:20 -0600

Hitender,

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

Dennis


On 3/3/06, hitender chugh <chughhk@xxxxxxxxxxx> 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
>
> -- //www.freelists.org/webpage/oracle-l
>

Other related posts: