Re: SGA / Latch Question

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Tue, 30 Dec 2008 11:34:50 -0800 (PST)
Message-ID: <3be3c81b-b95e-406d-a92c-4abd60ee06d7@d36g2000prf.googlegroups.com>

On Dec 30, 1:12 pm, mrdjmag..._at_aol.com wrote:
> Hi,
>
> This just seems weird.  I look at our SPFILE:  *.shared_pool_size=2G
>
> I query v$parameter: 1073741824
>
> I ran a query:
>
> SHARED_POOL_USED SHARED_POOL_SIZE SHARED_POOL_AVAILPCT_SHARED_POOL_AVL
> ---------------- ---------------- ------------------------------------
>       2107.04836             1024                 0205.766441
>
> Ok, so if I have 2GB in my spfile, and I bounced my database, why is
> it reading 1GB, unless I'm a dork and cannot read properly.......Size
> = 1GB and used = 2GB??
>
> Our sql library cache miss ratio says 99%, using that Spotlight
> utility and the latch waits are about 10%.  So, we figure we have a
> problem.....
>
> DUH??
Please provide the folowing information: Full Oracle version
values of database parameters:

sga_max_size
sga_target
pga_target

workarea_size_policy
shared_pool_size
db_cache_size

The actual query or queries you are using since the source cannot always be determined just from seeing output.

HTH -- Mark D Powell -- Received on Tue Dec 30 2008 - 13:34:50 CST