Ofcourse they are all true ! ;;-) Connor McDonald wrote:
> "..increasing the buffer hit ratio from 95 to 99 > percent can yield performance gains of over 400 > percent" > > "Retrieving data from memory is over 10000 times > faster than retrieving it from disk" > > "A more efficient method is to have the database write > to the redo logs only when all the log buffers are > filled or when a commit is issued. This happens when > log_checkpoint_interval is set to zero" > > "This allowed the O/S to dedicate a specific > background process to moving the log buffers upon > checkpoint to the redo files" > > "At times, specifying multiple hints can mysteriously > cause the query to use none of the hints" > > "The INDEX_DESC hint causes indexes to be sorted in > descending order...This index is overwritten when the > query has multiple tables" > > Cheers > Connor > > --- "Freeman, Robert " <[EMAIL PROTECTED]> > wrote: > Ok... one of my favorite Urban Legends is > this one: > > > > The book is always right. In other words, if it's > > written down > > in a book we bought off of Amazon, it must be so. > > > > So, I'd like to ask, without anyone taking potshots > > at > > specific authors, what is the dumbest, silliest, or > > most > > technically incorrect thing you have ever seen in an > > > > Oracle book? > > > > 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: [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). > > ===== > Connor McDonald > http://www.oracledba.co.uk (mirrored at > http://www.oradba.freeserve.co.uk) > > "Some days you're the pigeon, some days you're the statue" > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > 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: Anjo Kolk 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).
