Re: Free buffer requested

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).