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: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Tue, 26 Jun 2001 19:24:01 -0700
Message-ID: <F001.003395D4.20010626190531@fatcity.com>

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).
Received on Tue Jun 26 2001 - 21:24:01 CDT

Original text of this message

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