Re: Free buffer requested

By my calculation your generating 30 log switches an HOUR at 100MB per switch or 3GB per hour & you wonder why you're having a performance problems.

Try running bstat/estat & send the results off to www.oraperf.com for analysis.

com.banilejas_at_codetel.net.do wrote:
>
> Igor,
>
> Online redologs are 100MB size and in a different disk.
>
> Database is NOT in archive.
>
> Log switches are ocurring each 2 minutes.
>
> I am getting to the conclusion that the processing power of the computer is by far more than the disks can manage.
>
> Tks,
>
> Ramon
>
> -----Original Message-----
> From: "root_at_fatcity.com" <root_at_fatcity.com> on behalf of "Igor Neyman" <ineyman_at_perceptron.com>
> Sent: Wednesday, June 19, 2002 5:30 PM
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Subject: Re: Free buffer requested
>
> Ramon,
>
> Describing your file allocation, you don't tell, where your online RedoLogs.
> Also, are you running in archived mode? How often log switches occur?
>
> 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 4:33 PM
>
> > Anjo, Igor
> >
> > Apologies, didn't make myself clear.
> >
> > Redo log space wait time has a value of 58,554
> > Redo buffer allocation retries 18
> >
> > The another wait statistics where either 0 or pretty close to 0.
> >
> > With this value, I check the Performance manual, PDF version and in
> chapter
> > 19 page 7 makes reference to this statistic. I incremented the value and
> > nothing happened, initially was 50 MB, for that reason I stopped and ask
> for
> > help.
> >
> > HTH
> >
> > Ramon
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, June 19, 2002 1:53 PM
> >
> >
> > > Hi,
> > >
> > > I get easily confused, but you mention that 3 statistics are extremely
> > "high". Oracle
> > > has 200+ statistics, so the others are ok ?
> > > Why do you focus on these 3 ? You even fail to mention what you are
> doing
> > in these
> > > tests, so how can we tell you what to do ?
> > >
> > > Identify the symptoms (these processes need to run 3 times faster, for
> > example)
> > > Investigate the symptoms
> > > Formulate the root cause
> > > fix the the root cause
> > >
> > > I think that you are skipping a couple of stages in the problem solving
> > process,
> > >
> > > Anjo.
> > >
> > >
> > > com.banilejas_at_codetel.net.do wrote:
> > >
> > > > 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: Anjo Kolk
> > > INET: anjo_at_oraperf.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).
> --
> 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: Charlie Mengler
  INET: charliem_at_mwh.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).