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: Post, Ethan <epost_at_kcc.com>
Date: Tue, 26 Jun 2001 18:01:33 -0700
Message-ID: <F001.003395AB.20010626181604@fatcity.com>

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

Original text of this message

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