Note that tkprof's execution plan shows execution plan against current
database connection to which tkprof is connected. So, execution plan in
trace file and execution plan in tkprof output may be different. And, I
guess, tkprof shows first execution plan. If your statement parsed more
than once, Execution plans may be different.
have you run itrprof at
http://www.unal-bilisim.com/products/itrprof/itrprof.html .
It reports execution plans in trace files(so, correct execution plans) and
you can see all execution plan(s).
regards...
[EMAIL PROTECTED] wrote:
> I am trying to do some performance tuning on a user’s query by
> using tkprof. After running tkprof on the trace file (which
> was generated after using alter sessions set sql_trace true),
> I look at the results and they say
>
> error connecting to database using: /
> ORA-01017: invalid username/password; logon denied
>
> EXPLAIN PLAN option disabled.
> ****************************************
>
> However, the correct username/password is being used. Not sure
> what is going on with Explain plan. Any suggestions
>
> -----
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Web: http://www.unal-bilisim.com
*********
Questions and Answers: http://www.unal-bilisim.com/qa/discus/
*********
itrprof SQL Analyzer:
http://www.unal-bilisim.com/products/itrprof/itrprof.html
itrprof SQL Analyzer is a web based tool which analyzes
SQL_TRACE/Event10046 trace files of Oracle,
finds bottlenecks and offersinformation on how to tune them.
*********
iOraBugFinder:
http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html
iOraBugFinder is a web based tool which scans Oracle's alert log files,
ORA-600 and ORA-7445 trace files; extracts relevant information from them
and generates URL links to relevant bugs, notes, forums at Metalink.
*********
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment Gazi Unal (Unal Bilisim)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
