Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> explain in tkprof

explain in tkprof

From: Eugene <epipko_at_gmail.com>
Date: Wed, 01 Aug 2007 09:14:29 -0700
Message-ID: <1185984869.734916.268840@e9g2000prf.googlegroups.com>


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 Received on Wed Aug 01 2007 - 11:14:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US