Re: performance

I didn't mean to be so stiff on the reply -- sorry for that...

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" <ORACLE-L_at_fatcity.com> 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" <ORACLE-L_at_fatcity.com>
> 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" <ORACLE-L_at_fatcity.com>
> > 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" <ORACLE-L_at_fatcity.com>
> > > 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: vvnrk2001_at_yahoo.co.uk
> > > >
> > > > 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: Tim Gorman
> > INET: Tim_at_SageLogix.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: 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: Tim Gorman
  INET: Tim_at_SageLogix.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).