Re: explain in tkprof

From: <fitzjarrell_at_cox.net>
Date: Wed, 01 Aug 2007 09:47:31 -0700
Message-ID: <1185986851.109654.52860@x35g2000prf.googlegroups.com>

On Aug 1, 11:14 am, 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

The tkprof utility accepts user and password for explain; it doesn't accept TNS aliases. Please read the documentation:

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76992/ch14_str.htm#1256

David Fitzjarrell Received on Wed Aug 01 2007 - 11:47:31 CDT