> try to add this.... > where name = 'free memory' AND pool='shared pool' > > in the SELECT of v$sgastat > > ---------- > From: Ankur Shah[SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, June 13, 2001 10:35 PM > To: LazyDBA.com Discussion > Subject: Re: Flush shared poo; > > Same here Salman ! > > Any ideas Rahul > > Ankur Shah > Oracle DBA > DHR-GA > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> > Sent: Wednesday, June 13, 2001 8:28 AM > Subject: RE: Flush shared poo; > > > > > > query returned two rows, what does it mean?? > > TOTAL_SP FREE_MB PERCENT_FREE > > ---------- ---------- ------------ > > 160 10.38 6.49 > > 160 61.9 38.69 > > > > > > > > > > Rahul > > <rahul@rateli To: "LazyDBA.com > Discussion" > > ndo.co.id> <[EMAIL PROTECTED]> > > cc: > > 13/06/2001 Subject: RE: Flush shared > poo; > > 12:37 PM > > > > > > > > > > > > > > HUAHUAHUAHA !!! ... ....(shared poo ???) > > > > you could use this script.... > > select TOTAL_SP, > > FREE_MB, > > ROUND(((FREE_MB/TOTAL_SP) * 100),2) PERCENT_FREE > > from (select substr(value/1024/1024,1,10) TOTAL_SP from > v$parameter > > where > > name='shared_pool_size'), > > (select round((bytes/1024/1024),2) FREE_MB from v$sgastat > where > > name='free memory') > > / > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
