Question on SGA

From: <>
Date: Tue, 30 Dec 2008 10:10:04 -0800 (PST)
Message-ID: <>


This just seems weird. I look at our SPFILE: *.shared_pool_size=2G

I query v$parameter: 1073741824

I ran a query:


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

Original text of this message