Trace file output using TKPROF

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 ??

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

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