Re: RE: "SQL AREA" and "LIBARARY CACHE" size?

Hi Manoj,

to be frank : need to know more basic stuff before i peep into X$ tables. let me get good at fundamentals (a lot to be read & explored) first. later i can join u to explore about X$ stuff ;)

meanwhile,i'm waiting for someone to explain me about transient chunk & recurrent chunk.

Jp.

26-09-2003 19:19:25, "ManojKr Jha" <jmanoj_at_delhi.tcs.co.in> wrote:
>Hi Prem,
>I Think you are also doing the same mistake that I have done yesterday,
>that was causing so much confusion.
>I had earlier calculated the library cache and sql area size from X$ksmsp.
>Please check the size of these component in x$ksmss.
>WHat is difference in both x$ view is little bit confusing.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).