X-Received: by 10.224.184.11 with SMTP id ci11mr28594557qab.1.1357252640770; Thu, 03 Jan 2013 14:37:20 -0800 (PST) MIME-Version: 1.0 Received: by 10.49.116.139 with SMTP id jw11mr8562180qeb.12.1357252640748; Thu, 03 Jan 2013 14:37:20 -0800 (PST) Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!193.141.40.65.MISMATCH!npeer.de.kpn-eurorings.net!npeer-ng0.de.kpn-eurorings.net!feeder1-1.proxad.net!proxad.net!feeder1-2.proxad.net!209.85.216.87.MISMATCH!t8no739581qaj.0!news-out.google.com!k2ni4895qap.0!nntp.google.com!p13no744314qai.0!postnews.google.com!v7g2000yqv.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Thu, 3 Jan 2013 14:37:20 -0800 (PST) Complaints-To: groups-abuse@google.com Injection-Info: v7g2000yqv.googlegroups.com; posting-host=208.44.49.254; posting-account=_6ry2goAAAB8CmCVzS5u_8_rocyBncPn NNTP-Posting-Host: 208.44.49.254 References: User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0,gzip(gfe) Message-ID: <484081c7-42e2-40bb-a2b0-1308cc024a2d@v7g2000yqv.googlegroups.com> Subject: Re: Oracle Trace Analyzer From: John Hurley Injection-Date: Thu, 03 Jan 2013 22:37:20 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Xref: news.cambrium.nl On Jan 3, 2:28=A0pm, Mladen Gogala wrote: > I've just learned from the author that the venerable TRCA package uses > just PL/SQL to parse the trace files. That's why it's so slow and > resource consuming tkprof, orasrp and Cary's Method R profiler. There are > many parsing good tools but PL/SQL is not one of them. Most of the > parsing tools use finite automata which require lexer and grammar. Lexer > identifies the tokens while the grammar part performs the required > actions with the tokens. The most frequently used parsing tools are lex/ > yacc (flex/bison) and Perl. > That is why parsing of a 30MB trace file takes 10 minutes with TRCA and > it takes seconds with tkprof or orasrp. > > -- > Mladen Gogala > The Oracle Whispererhttp://mgogala.byethost5.com What is the Oracle Trace Analyzer? You mean tkprof? Everyone that I know uses either orasrp or Cary's tool. I licensed a copy of Cary's tool ( through hotsos pricing ... kind of weird ) ... but do not use it because I find the sorting options that orasrp to be superior. I find that my developers want to see long resource profiles contain SQL in the order that it was submitted into the oracle database engine. They can handle understanding that "not the first SQL in a resource profile is the SQL that needs attention first". I have asked for an enhancement to the Method R profiler but apparently Cary believes strongly in how the tool should produce output.