-
Hi,
How to use TKPROF Utility and run the TKPROF Utility.
Please explain step by step procedure.
Thanks in advance.
Regards,
Iyyappan.M
-
-
TKPROF - Urgent...
Hi,
Now i am created the trace file names like
'dummy_ora_2539.trc' In which prompt i will run the TKPROF
Utility. Either $ prompt or sys or system.
tkprof dummy_ora_2539.trc dummy_ora_2539.prf
explain = username/password TABLE = tablename
sys=no sort = (PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU)
Following syntax is correct or not.
Thanks in advance,
Regards,
Iyyappan....
-
hai you will have the tkprof exe in the bin folder.
so in the command prompt
c:\oraclehome\bin
give the command
tkprof dummy_ora_2539.trc dummy_ora_2539.prf
explain = username/password TABLE = tablename
sys=no sort = (PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU)
Good Judgement comes from Experience.
Experience comes from Bad Judgement
-
Just do:
tkprof file.trc file.txt
Then read the file normally.
Cheers
Angel
-
Hi
As per request i have run the command in command prompt
tkprof dummy_ora_2539.trc dummy_ora_2539.prf
explain = iyyappan/iyy table=spacemgm.spm_salstk
sys=no sort=(PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU)
I got following error: syntax error: `(' unexpected
I have run the command in /oracle_home/bin in solaris
env.
Expecting ur reply eagerly,
Thanks,
Iyyappan.M
-
I don't think you need the brackets round the sort options
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
TKPROF Syntax is correct or not? - Urgent
Hi
As per request i have run the command in command prompt
tkprof dummy_ora_2539.trc dummy_ora_2539.prf
explain = iyyappan/iyy table=spacemgm.spm_salstk
sys=no sort=(PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU)
The syntax is correct or not?
I got following error: syntax error: `(' unexpected
I have run the command in /oracle_home/bin in solaris
env.
Expecting ur reply eagerly,
Thanks,
Iyyappan.M
-
It looks like you've run the same statement, try:
tkprof dummy_ora_2539.trc dummy_ora_2539.prf
explain = username/password TABLE = tablename
sys=no sort =PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|