Re: Free buffer requested

Ramon,

Are you talking about "redo log space requests"? What about the value of "redo log space wait time"? I think, that's the statistic, you should be worried.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 19, 2002 1:18 PM

> 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" <ORACLE-L_at_fatcity.com>
> 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
> > ineyman_at_perceptron.com
> >
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > 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: com.banilejas_at_codetel.net.do
> >
> > 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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Igor Neyman
> > INET: ineyman_at_perceptron.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ramon E. Estevez
> INET: com.banilejas_at_codetel.net.do
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.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).