Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server Subject: Re: Can I, too, become an overpaid Oracle DBA (reissued in English) Date: 26 Apr 2005 07:58:52 -0700 Organization: http://groups.google.com Lines: 39 Message-ID: <1114527532.929720.53270@f14g2000cwb.googlegroups.com> References: <3q2dnRYwXODkIfDfRVn-vA@rogers.com> <1114524192.912153.176670@f14g2000cwb.googlegroups.com> NNTP-Posting-Host: 193.130.12.157 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1114527537 17876 127.0.0.1 (26 Apr 2005 14:58:57 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 26 Apr 2005 14:58:57 +0000 (UTC) In-Reply-To: User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: f14g2000cwb.googlegroups.com; posting-host=193.130.12.157; posting-account=YUT-nQ0AAACyUty0w2mW272E_Xv4Aa-F Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:241260 Jeremy wrote: > In article <1114524192.912153.176670@f14g2000cwb.googlegroups.com>, > Niall Litchfield says... > > > > You can also check out SimpleProfiler on my site and > > http://oracledba.ru/orasrp/ which are both inferior to the HOTSOS > > product in every way apart from cost. > > > > > > > > Did you actually mean what you wrote? Yes, though Egor's utility has advanced considerably since I last looked at it, so my comment was probably rather too unfair on him. The HOTSOS Profiler is fast, reliable and supported (as in your company can pay for it and get a support contract) as well as doing things like bind variable histograms and so on. Now I intend to improve SimpleProfiler (add proper documentation plus some other stuff for example) but it isn't what I would call commercial quality - and I don't have the resources or inclination to sell it as a commercial product. I don't believe that Egor has a commercial market in mind for his product either. If you are looking for a commercial quality, fast, reliable fully bug tested and supported profiler that enables you to implement the tuning methodology described in Cary's book then HOTSOS is the way to go, IMO. My effort definitely isn't, its a free, at your own risk kind of tool - and it owes a considerable amount to the Trace Analyzer utility written by Carlos Sierra of Oracle Corp anyway. I don't believe that Egor's would disagree significantly - but I've mailed him to allow him to speak for himself Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com