| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Common Oracle RDBMS Misconceptions
well, the slides are at: http://www.ooug.org/slides.html
i'm trying to find a copy of the paper... we gave it in Ohio and at ECO but I don't see the paper on their sites. Once I get a copy, it will get posted to the NYOUG site (www.nyoug.org)
Rachel
>From: kjanusz_at_att.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 12:26:20 -0800
>
>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).
-- 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).Received on Tue Jun 26 2001 - 19:09:36 CDT
 |
 |