SGA / Latch Question

From: <>
Date: Tue, 30 Dec 2008 10:12:41 -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 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

Original text of this message