OT: Re: Common Oracle RDBMS Misconceptions

Rachel, i'm not even on the board(OOUG) anymore(seems most people forget that).

Hit up Kevin, he's playing webmaster.

joe
Rachel Carmichael wrote:
>
> dunno... it's their site. oh JOE!!!!!!!!!
>
> I'll see if I can get it fixed there. If not, again, will see if I can get
> it onto the NYOUG site
>
> >From: "Post, Ethan" <epost_at_kcc.com>
> >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 18:16:04 -0800
> >
> >Couldn't open it with PPT 97. - E
> >
> >-----Original Message-----
> >Sent: Tuesday, June 26, 2001 6:10 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >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).
> >
> >_________________________________________________________________
> >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).
> >
> >------------------------------------------------------------------------------
> >This e-mail is intended for the use of the addressee(s) only and may
> >contain privileged, confidential, or proprietary information that is exempt
> >from disclosure under law. If you have received this message in error,
> >please inform us promptly by reply e-mail, then delete the e-mail and
> >destroy any printed copy. Thank you.
> >
> >==============================================================================
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Post, Ethan
> > INET: epost_at_kcc.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).
>
> _________________________________________________________________
> 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)

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: teci_at_the-testas.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).