Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.news2me.com!newsfeed2.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sn-xit-02!sn-xit-12!sn-xit-09!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: CBO influences Date: Thu, 15 Sep 2005 08:45:04 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1126799052.142560@yasure> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1126283179.991124.138480@z14g2000cwz.googlegroups.com> <1126284892.947680.217710@g44g2000cwa.googlegroups.com> <1126294364.813025.287860@o13g2000cwo.googlegroups.com> <1126306293.634107@yasure> <1126329859.958172@yasure> <1126374364.66827@yasure> <43282C72.36FC@yahoo.com> <43297223.D8E@yahoo.com> In-Reply-To: <43297223.D8E@yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 46 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251613 Connor McDonald wrote: >>Don't share a SAN if you want to run a high >>performance OLTP system - they're not very >>good for small, highly randomised I/Os. >> >>-- >>Regards >> >>Jonathan Lewis >> >>http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html >>Cost Based Oracle - Volume 1: Fundamentals >>On-shelf date: Nov 2005 >> >>http://www.jlcomp.demon.co.uk/faq/ind_faq.html >>The Co-operative Oracle Users' FAQ >> >>http://www.jlcomp.demon.co.uk/appearances.html >>Public Appearances - schedule updated 4th Sept 2005 > > > I would generalise to SAN's are not good at IO... period > > :-) That has not been my experience. What I have found is that often storage admins say to the DBA: "You asked for 60 gigs ... I gave you 60 gigs" and put it all on one 400GB disk or one LUN. Properly configured the story changes dramatically. Kent Stroker, formerly Oracle's SE of the year (two years in a row) and an expert on RAC and storage has many times during his public lectures stated that the one of the biggest tuning problem facing most installations he sees is improperly presented disks. There is no operating system or Oracle instrumentation capable of telling you that the storage admin made bad decisions. So often we end up tuning, as best we can, given what we got. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)