RE: RE: Fav. Urban Legend...

This may have already been stated, but how about:

Making your SGA size bigger will always yield performance gains.

There is a Law of Diminishing Returns at work when all the latches, free lists, etc. are taken into account for managing such a large SGA...

Jim

"Orr, Steve" <sorr_at_rightnow.com> wrote:

>Bigger is better.
>This is the best biggest myth. Say that fast 3 times. :-)
>
>-----Original Message-----
>Sent: Wednesday, March 13, 2002 5:18 AM
>To: Multiple recipients of list ORACLE-L
>
>
>That as Oracle software becomes larger, fewer DBAs are required.
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>Systems Admin & Operations | Admin. et Exploit. des systèmes
>Technology Services | Services technologiques
>Informatics Branch | Direction de l'informatique
>Maritimes Region, DFO | Région des Maritimes, MPO
>
>E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
>
>
> -----Original Message-----
>Sent: Wednesday, March 13, 2002 12:28 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: Fav. Urban Legend...
>
>oh man, mine has to be what is probably Jeremiah's as well:
>
>the myth that Oracle doesn't write to the database files when you are
>in hot backup mode
>
>
>--- "Freeman, Robert " <Robert_Freeman_at_csx.com> wrote:
>> I'm putting the final touches on my IOUG-A presentation (I got an
>> extension
>> for those who
>> realize that I'm late on it!)... I'm doing Oracle Urban Legends. I've
>> got
>> several in my presentation but I thought I'd ask here, before I put
>> the
>> presentation to bed, what your favorite (or the one you find the most
>> irritating) Oracle Urban legend was....
>>
>> RF
>>
>> Robert G. Freeman - Oracle8i OCP
>> Oracle DBA Technical Lead
>> CSX Midtier Database Administration
>>
>> The Cigarette Smoking Man: Anyone who can appease a man's conscience
>> can
>> take his freedom away from him.
>>
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Freeman, Robert
>> INET: Robert_Freeman_at_csx.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).
>
>
>__________________________________________________
>Do You Yahoo!?
>Try FREE Yahoo! Mail - the world's greatest free email!
>http://mail.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: wisernet100_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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>
>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: Orr, Steve
> INET: sorr_at_rightnow.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).
>

-- 
_____________________________
Jim Hawkins
Oracle Database Administrator
VelvetMellocet_at_netscape.net
St. Louis, MO  USA



__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Hawkins
  INET: VelvetMellocet_at_netscape.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).