| 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
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).
-- 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 - 12:14:24 CDT
 |
 |