Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Free buffer requested

Re: Free buffer requested

From: Alexandre Gorbatchev <alexandre.gorbatchev_at_avermann.de>
Date: Thu, 20 Jun 2002 23:43:23 -0800
Message-ID: <F001.00483DAB.20020620234323@fatcity.com>


I assume that you run it for 2,5 hours when proces was running. So you generate lots of redo log info and that took 20 mins to write it. I think redo logs are doing fine for a update-intensive batch process.

--
Alexandre
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, June 20, 2002 6:33 PM



> I executed the process using b/e/stat
>
> Statistic
> Total
> ---------------------------------------------------------------- ---------
--
> -
> Per Transaction Per Logon Per Second
> --------------- ------------ ------------
> redo blocks written
> 1169331
> 146166.38 86617.11 794.92
>
> redo buffer allocation retries
> 776
> 97 57.48 .53
>
> redo entries
> 382054
> 47756.75 28300.3 259.72
>
>
> Statistic
> Total
> ---------------------------------------------------------------- ---------
--
> -
> Per Transaction Per Logon Per Second
> --------------- ------------ ------------
> redo log space requests
> 25
> 3.13 1.85 .02
>
> redo log space wait time
> 2189
> 273.63 162.15 1.49
>
> redo ordering marks
> 190
> 23.75 14.07 .13
>
> Statistic
> Total
> ---------------------------------------------------------------- ---------
--
> -
> Per Transaction Per Logon Per Second
> --------------- ------------ ------------
> redo wastage
> 130984
> 16373 9702.52 89.04
>
> redo write time
> 116751
> 14593.88 8648.22 79.37
>
> redo writer latching time
> 1
> .13 .07 0
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, June 19, 2002 8:53 PM
>
>
> > 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).
>
> --
> 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: Alexandre Gorbatchev INET: alexandre.gorbatchev_at_avermann.de 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).
Received on Fri Jun 21 2002 - 02:43:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US