Re: explain in tkprof

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 02 Aug 2007 17:30:43 -0700
Message-ID: <1186101043.234788.247020@q3g2000prf.googlegroups.com>

On Aug 1, 12:14 pm, Eugene <epi..._at_gmail.com> wrote:
> Hi all,
> I am running Oracle 8.1.6.3 on Win NT4 and having a prblem displaying
> explain plan in tkprof.
> -----------------------------------------------------------------------
> set oracle_sid=sid
> tkprof ora00128.trc tk_out.txt sort=exeela,fchela explain=sys/
> pass_at_my_db;
> -----------------------------------------------------------------------
> I am getting an output file just fine, but w/out explain plan.
> File has the fillowing error it:ORA-12154: TNS:could not resolve
> service name,
> I can login using same usernam/pass in SQL*Plus however.
>
> Thanks,
> Eugene

You might want to consider using orasrp. Much more comprehensive output and more accurate than tkprof.

See Cary Millsap's book "Optimizing Oracle Performance" or www.hotsos.com Received on Thu Aug 02 2007 - 19:30:43 CDT