RE: Free buffer requested

Ramon - Just to follow that thought, and I apologize if you've responded to this already, how is the disk I/O? Are the controllers very busy? What is the I/O distribution across devices? Is it RAID5? If so, how much RAM does the RAID controller have?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, June 19, 2002 8:28 PM
To: Multiple recipients of list ORACLE-L

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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).