Jeremiah,
You've hit most of mine, but here are a few more:
- It's OK to continue using a db after you've forced
it open.
- To remove a datafile from the db, all you need to
do is offline drop it.
- All there is to switching from RBO to CBO is to
analyse the tables.
- You can apply archived logs to an export.
- TRANSACTIONS_PER_ROLLBACK_SEGMENT determines the
max # of transactions that can use a rollback segment.
- The way to resolve enqueue waits is to increase
ENQUEUE_RESOURCES.
- If OPTIMIZER_MODE=RULE then the RBO will always be
used. Closely related to, if tkprof shows RULE then
the RBO was used.
- When in doubt, recreate the controlfile.
- All changes to the data dictionary use the system
RBS.
OK, so it was more than a few ;)
- Anita
- Jeremiah Wilton <jwilton_at_speakeasy.net> wrote:
> 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).
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.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 - 13:22:57 CDT
