SGA
From: <mrdjmagnet_at_aol.com>
Date: Tue, 30 Dec 2008 09:58:23 -0800 (PST)
Message-ID: <72112dbd-b6ac-4d18-a3ad-bd5c41916ebb@k1g2000prb.googlegroups.com>
Date: Tue, 30 Dec 2008 09:58:23 -0800 (PST)
Message-ID: <72112dbd-b6ac-4d18-a3ad-bd5c41916ebb@k1g2000prb.googlegroups.com>
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_AVAIL PCT_SHARED_POOL_AVL
---------------- ---------------- -----------------
-------------------
2107.04836 1024 0
205.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??
DUH?? Received on Tue Dec 30 2008 - 11:58:23 CST