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

Re: OT: Re: Common Oracle RDBMS Misconceptions

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Wed, 27 Jun 2001 02:56:55 -0700
Message-ID: <F001.00339A08.20010627024526@fatcity.com>

Joe,

Oops, not that I forgot, I don't think I knew.

okay.... KEVIN!!!!!!!!!!!!!!! :)

Will send him a new copy to put up there.

Rachel

>From: teci_at_the-testas.net
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: OT: Re: Common Oracle RDBMS Misconceptions
>Date: Tue, 26 Jun 2001 20:30:31 -0800
>
>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).



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).
Received on Wed Jun 27 2001 - 04:56:55 CDT

Original text of this message

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