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: Common Oracle RDBMS Misconceptions

Re: Common Oracle RDBMS Misconceptions

From: <kjanusz_at_att.net>
Date: Tue, 26 Jun 2001 12:53:23 -0700
Message-ID: <F001.00338DF1.20010626122620@fatcity.com>

Where can I get the "exploding the myths" paper?

Thanks,
Ken Janusz, CPIM
> Jeremiah,
>
> Marlene and I did an "exploding the myths" paper very similar to what you
> are doing..
>
> "always set pctincrease on your temporary tablespace to 1"
>
> and my OOW submission is very very similar to yours. Not quite, but really
> close.
>
> It will be interesting to see if they choose one, both or neither of our
> papers :)
>
> Rachel
>
> >From: Jeremiah Wilton <jwilton_at_speakeasy.net>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Common Oracle RDBMS Misconceptions
> >Date: Tue, 26 Jun 2001 09:05:27 -0800
> >
> >All right folks, I'm collecting misconceptions, of the type held by newbies
> >and
> >oldtimers alike. My OOW proposal this year is for a presentation and paper
> >on a
> >whole laundry list of these things, similar to what I wrote for hot backup.
> > I
> >want to share what I have so far and solicit input for your favorites (pet
> >peeves). I most certainly will credit individuals and this list for any
> >ideas I
> >glean.
> >
> >So far my favorite misconceptions are:
> >
> >* Hot backup stops writing to datafiles
> >* All network communication is done through the listener
> >* Always 'switch logfile' after (before, inbetween) hot backups
> >* Media recovery is required if you crash during backup mode
> >* Cold backup once a week ("just in case," "as a 'baseline'")
> >* Export is a good way to back up your database
> >* Shutdown abort is bad, crash recovery time is as long as 'shutdown
> >immediate'
> >* Listener.log/alert.log clearing confusion
> >* ORA-1555 can be solved by setting transaction (use specific rollback seg)
> >* Big batch jobs should use one big RBS
> >* ORA-600 means you have corruption / just call support for ORA-600
> >* Lots of extents are bad
> >* Databases can't be renamed
> >* Select count (1) is better than count (*).
> >* Listeners have to be started before the instance
> >* NOLOGGING turns off logging for all operations
> >* Oracle Corp. won't support NFS datafiles
> >* checkpoint not complete - misguided solutions
> >* Must reinstantiate standby after failover by recopying
> >* redolog size change requires outage
> >
> >What's *your* pet misconception?
> >
> >--
> >Jeremiah Wilton
> >http://www.speakeasy.net/~jwilton
> >
> >On Tue, 26 Jun 2001, novicedba wrote:
> >
> > > I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
> > > I was shocked to read Hot backup mode explained
> > > If this is true then I may be a victim of a disease called
> > > 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim
> >carrey-MASK style)
> > > Please help me. If some one has few more articles like this enlighten me
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Jeremiah Wilton
> > INET: jwilton_at_speakeasy.net
> >
> >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).
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.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: kjanusz_at_att.net

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 Tue Jun 26 2001 - 14:53:23 CDT

Original text of this message

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