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" <[EMAIL PROTECTED]> 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" <[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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev 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).
