Trace file output using TKPROF

[bang_dba]

I am not getting explain plan in the tkprof Trace file. The sysntax i used is as following


tkprof tcr_proc_3134.trc tcr_proc_3134.out
explain=scott/tiger$ sys=no


I also used 'scott/tiger$'
scott/tiger$@dbs
'scott/tiger$@dbs'

But every time i am getting the error
***************************************************
error connecting to database using: scott/tiger$@dbs
EXPLAIN PLAN option disabled.
***************************************************



Also if a query is running in the Loop does the query appear only once in the Trace file ?
how can i identify the Amount of time a query is taking in each run in the trace file output file


call count cpu elapsed
--------- ---------- ----------
Parse 0.00 0.00 0
Execute 1 0.01 0.00
Fetch 372 0.10 0.14
------- ------ -------- ----------
total 374 0.11 0.14

Can somebody guide me ??

[davey23uk]

dont use explain=..... it wont tell you what happend in your query, but what would happen if you ran it now

[tamilselvan]

Did you set up plan table correctly?

If your OS is unix, try this
tkprof tcr_proc_3134.trc tcr_proc_3134.out explain=scott/tiger\$ sys=no

Tamil