RE: OT: Re: Common Oracle RDBMS Misconceptions
thanks I thought it would be a good way to end it on a smile >From: "Guy Hammond" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT: Re: Common Oracle RDBMS Misconceptions >Date: Fri, 29 Jun 2001 08:11:48 -0800 > >Rachel, I love those animations on the last slide!! :0) > >g > > >-Original Message- >Sent: Wednesday, June 27, 2001 11:45 AM >To: Multiple recipients of list ORACLE-L > > >Joe, > >Oops, not that I forgot, I don't think I knew. > >okay KEVIN!!! :) > >Will send him a new copy to put up there. > >Rachel >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Guy Hammond > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: OT: Re: Common Oracle RDBMS Misconceptions
Rachel, I love those animations on the last slide!! :0) g -Original Message- Sent: Wednesday, June 27, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up there. Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: OT: Re: Common Oracle RDBMS Misconceptions
"Toepke, Kevin M" wrote: > > Rachel: > > The problem seems to be the ftp from work to the OOUG web site (it gets > corrupted in the transfer.) I'll try again later from home. > > Kevin > > -Original Message- > Sent: Wednesday, June 27, 2001 6:45 AM > To: Multiple recipients of list ORACLE-L > > Joe, > > Oops, not that I forgot, I don't think I knew. > > okay KEVIN!!! :) > > Will send him a new copy to put up there. > > Rachel > Rachel, In the presentation, I saw: always set timed_statistics=true having lots of extents is not a problem - |lots|= ??? Care to repent - or stipulate that it was for a de-supported (or soon to be) version? Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: OT: Re: Common Oracle RDBMS Misconceptions
Rachel: The problem seems to be the ftp from work to the OOUG web site (it gets corrupted in the transfer.) I'll try again later from home. Kevin -Original Message- Sent: Wednesday, June 27, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up there. Rachel >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: OT: Re: Common Oracle RDBMS Misconceptions >Date: Tue, 26 Jun 2001 20:30:31 -0800 > >Rachel, i'm not even on the board(OOUG) anymore(seems most people forget >that). > >Hit up Kevin, he's playing webmaster. > >joe >Rachel Carmichael wrote: > > > > 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" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >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: [EMAIL PROTECTED] > > > >Reply-To: [EMAIL PROTECTED] > > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > >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 <[EMAIL PROTECTED]> > > > > > >Reply-To: [EMAIL PROTECTED] > > > > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > > > >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 &g
Re: OT: Re: Common Oracle RDBMS Misconceptions
Joe,
Oops, not that I forgot, I don't think I knew.
okay KEVIN!!! :)
Will send him a new copy to put up there.
Rachel
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OT: Re: Common Oracle RDBMS Misconceptions
>Date: Tue, 26 Jun 2001 20:30:31 -0800
>
>Rachel, i'm not even on the board(OOUG) anymore(seems most people forget
>that).
>
>Hit up Kevin, he's playing webmaster.
>
>joe
>Rachel Carmichael wrote:
> >
> > 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" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >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: [EMAIL PROTECTED]
> > > >Reply-To: [EMAIL PROTECTED]
> > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > >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 <[EMAIL PROTECTED]>
> > > > > >Reply-To: [EMAIL PROTECTED]
> > > > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > > > >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
OT: Re: Common Oracle RDBMS Misconceptions
Rachel, i'm not even on the board(OOUG) anymore(seems most people forget
that).
Hit up Kevin, he's playing webmaster.
joe
Rachel Carmichael wrote:
>
> 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" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >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: [EMAIL PROTECTED]
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >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 <[EMAIL PROTECTED]>
> > > > >Reply-To: [EMAIL PROTECTED]
> > > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > > >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: [EMAIL PROTECTED]
> > > > >
> > > > >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: [EMAIL PROTECTED]
RE: OT RE: Common Oracle RDBMS Misconceptions
I guess I shudda thrown a smiley in there. yikes... Anyway, I hope i am not in the minority when i say that i think hit ratios *are* important, even in tuning. I just don't think they are the sine qua non of tuning. -Original Message- Sent: Tuesday, June 26, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Gaja makes very good points about the importance of hit ratios but I don't think we should go 180 degrees the other way and abandon them all together. They certainly tell us something. They just shouldn't necessarily be a tuning goal. However, most of us are only seeing the hit ratio as of database startup. This is somewhat meaningless. If you are aware of your hit ratios as they look throughout the average day they become more meaningful when something is awry. I think the real misconception is "bad hit ratio = more memory" or "bad hit ratio = bad dba". This is what we need to clear up and bring some commen sense to. - Ethan -Original Message- Sent: Tuesday, June 26, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Yea, "hit ratios" are never important. Ever. For anything. -- 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: OT RE: Common Oracle RDBMS Misconceptions
Gaja makes very good points about the importance of hit ratios but I don't think we should go 180 degrees the other way and abandon them all together. They certainly tell us something. They just shouldn't necessarily be a tuning goal. However, most of us are only seeing the hit ratio as of database startup. This is somewhat meaningless. If you are aware of your hit ratios as they look throughout the average day they become more meaningful when something is awry. I think the real misconception is "bad hit ratio = more memory" or "bad hit ratio = bad dba". This is what we need to clear up and bring some commen sense to. - Ethan -Original Message- Sent: Tuesday, June 26, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Yea, "hit ratios" are never important. Ever. For anything. -- 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
OT RE: Common Oracle RDBMS Misconceptions
I think it's on a site somewhere in Bulgaria. -Original Message- Sent: Tuesday, June 26, 2001 2:47 PM To: Multiple recipients of list ORACLE-L Rachel, I am interested in reading your paper - Exploding the Myths. How do I get access to this paper? Is it available on any website? Thanks Rao -Original Message- Sent: Tuesday, June 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
OT RE: Common Oracle RDBMS Misconceptions
Yea, "hit ratios" are never important.
Ever.
For anything.
-Original Message-
Sent: Tuesday, June 26, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L
Based on Gaja's book, tune based on waits not based on hit ratios.
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Tuesday, June 26, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Terrian, Tom
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Mohan, Ross
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
