Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> lib cache & sql area in V$SGASTAT

lib cache & sql area in V$SGASTAT

From: Rahul <rahul_at_ratelindo.co.id>
Date: Tue, 1 Aug 2000 09:54:29 +0700
Message-Id: <10575.113441@fatcity.com>


List,
when selecting * from v$sgastat it shows library cache and sql area separately !!

------------+----------+-----------+------------

library cache               24300368
sql area                    47234680

------------+----------+-----------+------------

library cache contains shared namespaces..which INCLUDES sql/plsql/ and object definitions , right ?

so..what does "sql area" contain ??

TIA Received on Mon Jul 31 2000 - 21:54:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US