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" <[EMAIL PROTECTED]>
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.
> [EMAIL PROTECTED]
>
>
> -----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: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> on behalf of "Igor
> Neyman" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 19, 2002 5:30 PM
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> 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
> [EMAIL PROTECTED]
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> 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" <[EMAIL PROTECTED]>
> > 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.
> > >
> > >
> > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> > > >
> > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
