Re: High elapsed/cpu ratio

From: <ebwright_at_gmail.com>
Date: Tue, 11 Sep 2007 13:16:59 -0700
Message-ID: <1189541819.331220.220880@i13g2000prf.googlegroups.com>

On Sep 11, 3:10 pm, Jan Krueger <j..._at_stud.uni-hannover.de> wrote:

> May I suggest to use Oracle's traceanalyzer available for download from
> metalink Note:224270.1.
> Also another tool of carlos sierra is available named sqltxplan, quite
> usefull for single statment analysis.
>
> In my personal opinion tkprof is a legacy tool.
>
> Jan

We have this installed in our production env. Our DBA has provided results from sqltxplan to Oracle to help with performance on a related issue. I'll see if I can get my query analyzed with this tool and look at the results.

Thanks
Eric Received on Tue Sep 11 2007 - 15:16:59 CDT