SGA / Latch Question

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?? Received on Tue Dec 30 2008 - 12:12:41 CST