| 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
How about timed_statistics=true is a performance overhead. Or you still worry about temp segments not being released after a sort.
>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: Mike Killough INET: mwkillough_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 - 12:39:09 CDT
 |
 |