> I didn't mean to be so stiff on the reply -- sorry for that... You are excused... Just kidding. :-) I didn't mean that either - my apologies.
And you may be very right on the political perspective. What's done is done. It could be not the right time for late general setups, but analysis is always a good choice. > The most common issues in the redo stream are certainly sizing and I/O. > Yes, it can be quite cut-and-dried. But Ravi merely mentioned that > "performance was slower" after enabling ARCHIVELOG mode and for all we know, > it truly may have nothing to do with the redo logging stream whatsoever. It > could be something else (i.e. bad SQL that someone recently slammed in at > the same time) that neither Ravi (nor we) are aware of. It could be > anything at all... > > So, making changes in the complete absence of information can easily end up > with the following scenario: Ravi makes the recommended changes (i.e. add > redo log groups, change group sizes, pester SysAdmins to create new > file-systems to separate online from archived destinations, etc), all with > no impact on performance. Thus, his credibility is harmed, if not totally > destroyed. Happens all the time...(8 million stories in the naked city)... > > Better to look first, understand exactly what is happening, and act on real > information. > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 7:53 AM > > > > I've assumed, that nothing changed beside ARCHIVE LOG mode. "when Our DB > is > > non-archive mode that was ok,when we moved to Archive, it is dead slow" > > This directs to the question of I/O with archiving redo logs in first > turn. > > Doesn't it? What may be other direct performance issues of ARCHIVE LOG > mode? > > I admit that there is not enough information, which may easily make me > > mistaken. However, there should be some general setup for archive log > mode, > > and that's what I gave. General setup should be made before moving to > > archivelog mode and taken as basis for further tuning. > > > > Alexandre > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Monday, July 01, 2002 2:43 PM > > > > > > > Alexandre, > > > > > > I beg to differ. > > > > > > You have assumed, in the complete absence of any information, that he > has > > an > > > I/O problem. He might. He also might not. He should look first, > before > > > leaping. > > > > > > -Tim > > > > > > ----- Original Message ----- > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Monday, July 01, 2002 1:53 AM > > > > > > > > > > Ravi, > > > > > > > > Make sure you have at least 5-10 redo log groups. That's depends on > your > > > > workload. You also may need to increase their size. Think how much log > > > info > > > > your database can generate and size your logs that it would be enough > > for > > > 10 > > > > mins at least. (Of course that would be pretty rough estimation) > > > > Also make sure you put redo logs and arcived redo logs on differend > > disks! > > > > So that's for start. After, you may follow advice given in Tim's > reply. > > > > > > > > hth > > > > Alexandre > > > > ----- Original Message ----- > > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > > Sent: Saturday, June 29, 2002 9:13 PM > > > > > > > > > > > > > Dear All, > > > > > > > > > > Can any one please give me some hints or tips when we > > > > > move to archive mode? when Our DB is non-archive mode > > > > > that was ok,when we moved to Archive, it is dead slow. > > > > > > > > > > Obviosuly archive mode performance is slow, is there > > > > > any other precations to be taken care? > > > > > > > > > > Thanks for your help. > > > > > Cheers, > > > > > Ravi > > > > > > > > > > __________________________________________________ > > > > > Do You Yahoo!? > > > > > Everything you'll ever need on one web page > > > > > from News and Sport to Email and Music Charts > > > > > http://uk.my.yahoo.com > > > > > -- > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > -- > > > > > Author: =?iso-8859-1?q?Nalla=20Ravi?= > > > > > 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). > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Tim Gorman > > > 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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tim Gorman > 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).
