I'm also dying to know how much of that 1G shared pool is full... --- Anjo Kolk <[EMAIL PROTECTED]> wrote: > I am getting more confused (as per my previous > answer on this subject). > > 200 MB log buffer is HUGE and totally not needed at > all. If "free buffer > requested" is too high (and what is too high), > increasing log_buffer won't do > you any good. > Please quote: title, chapter, pageno that tells you > to do this ...... > > > Anjo. > > > "Ramon E. Estevez" wrote: > > > Tks Igor for your answer, > > > > It's 200 MB, sorry, for log buffer. > > > > According to the v$sysstat view, the value of free > buffer requested was too > > high and increasing, so decided to add more, > previously was 50 MB and the > > same results. > > > > I checked the RTFM and said that increase the > log_buffer parameter or add > > more dbwriters. > > > > First I increased to 100MB, the same results, > later 200MB and the same > > results also. > > > > That says that the problem is for other side, I'm > going in the wrong > > direction. > > > > Don't know what else to check. The process is > running alone in the server, > > just one connection. > > > > Ramon > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > > Sent: Wednesday, June 19, 2002 11:03 AM > > > > > What is "200BBM" (for log buffer)? > > > If it's 200MB - it's huge! > > > > > > Igor Neyman, OCP DBA > > > [EMAIL PROTECTED] > > > > > > > > > > > > ----- Original Message ----- > > > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > > > Sent: Tuesday, June 18, 2002 9:33 PM > > > > > > > > > > > > Hi list, > > > > > > Scenario Sun 880 Solaris 8, Oracle 8.1.7.3, 8GB > Ram, 4 processors > > > > > > Redo logs 200MB size 4 groups in 1 disk > > > DBWriter = 2 > > > log buffer 200 BM > > > Shared Pool 1 GB > > > db block buffers 100,000 > > > db block size 8K > > > > > > I started a process and checked the V$sysstat > and get those values are > > > extremely high > > > > > > free buffer requested 28938, enqueue requests > 25035, redo writer latching > > > time 0 > > > > > > Data 1 volume stripe of 2 disk > > > Index 1 volume stripe of 2 disk -- differents > > > RBS 1 disk apart > > > Temp 1 disk apart > > > > > > What parameter should I check ? > > > > > > > > > TIA > > > > > > Ramon E. Estevez > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > > -- > > > Author: > > > 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). > > > > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > > -- > > > Author: Igor Neyman > > > 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). > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Ramon E. Estevez > > 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). > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Anjo Kolk > 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).
===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).