How to use TKPROF Utility?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: How to use TKPROF Utility?

  1. #1
    Join Date
    Jun 2002
    Posts
    88
    Hi,

    How to use TKPROF Utility and run the TKPROF Utility.

    Please explain step by step procedure.

    Thanks in advance.

    Regards,
    Iyyappan.M

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

  3. #3
    Join Date
    Jun 2002
    Posts
    88

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

  4. #4
    Join Date
    Apr 2002
    Posts
    135
    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

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Just do:

    tkprof file.trc file.txt

    Then read the file normally.

    Cheers

    Angel

  6. #6
    Join Date
    Jun 2002
    Posts
    88
    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

  7. #7
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  8. #8
    Join Date
    Jun 2002
    Posts
    88

    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

  9. #9
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  10. #10
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width