Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Waits on latch free for shared_pool & library Cache
Bull's eye .
Will Check out the Steve Adams' Book & revert
Thanks
> -----Original Message-----
> From: yong huang [SMTP:yong321_at_yahoo.com]
> Sent: Monday, February 05, 2001 10:30 AM
> To: oracledba_at_lazydba.com
> Cc: VIVEK_SHARMA_at_infy.com
> Subject: Re: Waits on latch free for shared_pool & library Cache
>
> Hi, Vivek,
>
> I can't answer your question. But I know where you get the understanding
> of
> freeabl and perm chunks of shared pool memory (Richard Niemiec, "Oracle
> Performance Tuning", p.615). I don't comment on the overall quality of the
> book
> here but I seriously doubt his explanation of "perm". Steve Adams's note
> says
> "perm: Permanent memory chunks contain persistent objects..." (Steve
> Adams'
> book, p.94)
>
> Yong Huang
> yong321_at_yahoo.com
>
> you wrote:
>
> > - Waits on Latch Free for shared_pool , Library Cache Phenominally High
> > Qs. What may be Done for the Same ?
> [snipped]
> > freeabl - most probably stands for the memory that has been used but is
> > freeable
> > perm - most probably stands for the free memory not yet moved to free
> area
> > for use
>
> __________________________________________________
> Get personalized email addresses from Yahoo! Mail - only $35
> a year! http://personal.mail.yahoo.com/
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: VIVEK_SHARMA_at_infy.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).Received on Mon Feb 05 2001 - 04:32:20 CST