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. So, we figure we have a problem.....

DUH??