Results 1 to 4 of 4

Thread: Explain Plan & Tkprof

  1. #1
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Explain Plan & Tkprof

    What is difference between Explain plan & TKProf?


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Explain Plan & Tkprof

    Explain plan displays the output of the plan at sql prompt itself in sql * plus . tkprof creates a separate report file in text format . There is difference in output of both.


  3. #3
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Explain Plan & Tkprof

    Quote Originally Posted by babi_geek View Post
    What is difference between Explain plan & TKProf?
    u can find clear explanation here


  4. #4
    Junior Member
    Join Date
    Oct 2008
    Answers
    1

    Re: Explain Plan & Tkprof

    EXPLAIN PLAN is a statement that allows you to have Oracle generate the execution plan for any SQL statement without actually executing it. You will be able to examine the execution plan by querying the plan table.
    A plan table holds execution plans generated by the EXPLAIN PLAN statement.

    TKPROF is a utility provided by Oracle that formats SQL trace files into very helpful and readable reports. TKPROF is installed automatically when the database server software is installed. You invoke TKPROF from the operating system command line; there is no graphical interface for TKPROF


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact