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: Ramon E. Estevez <com.banilejas_at_codetel.net.do>
Date: Fri, 21 Jun 2002 06:13:19 -0800
Message-ID: <F001.00484123.20020621061319@fatcity.com>


Yes it was.

The suppliers took the server and the oracle software to reinstall everything. They blame the DB configuration. They are going to look for an expert to install and configure the DB.

Ramon

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

-- 
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).
Received on Fri Jun 21 2002 - 09:13:19 CDT

Original text of this message

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