Posted on 2012-09-12
Last Modified: 2012-09-27
how will I know that tkprof is there in oracle..
How will I start it ?
Question by:tomvv
    LVL 73

    Accepted Solution

    it will be in your oracle home "bin" directory

    it will be called tkprof

    for example


    if your oracle home bin is part of your default PATH then you can simply enter

    tkprof  at the command line and it will print the banner
    LVL 73

    Expert Comment

    to find your oracle home setting in unix platforms...

    echo $ORACLE_HOME

    to see your path

    echo $PATH
    LVL 23

    Expert Comment

    If you will search the E-E knowledge base, you will find many articles on how to use the tool, in addition to the Oracle site forums.
    LVL 34

    Expert Comment

    by:Mark Geerlings
    If you have a UNIX or Linux server, and if you are logged in to the server as the owner of the Oracle software, you should have the aliases: $ORACLE-HOME and $PATH already defined.  So, you can simply type "tkprof" and it should start.  Your $PATH should include the /bin folder of your $ORACLE-HOME.  (Sorry, I'm trying this on my new iPad and that keyboard doesn't have an underscore character, so I used a dash instead.)
    LVL 34

    Expert Comment

    by:Mark Geerlings
    I found the underscore now on my iPad keyboard (_) and a number of other non-numerical and non-alphabetic characters also. After clicking the ".123" key to bring up the numeric keypad, the "#+=" key there brings up a keyboard of special characters.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now