News, views, tips and tricks on Oracle and other fun stuff

How do you use tkprof to solve a performance problem?

In his latest article, Jonathan Lewis uses tkprof to analyse the performance of a query. He concluded that “When you examine the output from tkprof, it often takes a simultaneous cross-check of the block level statistics, the Row Source Operation counts, and some sensible guesswork about the purpose of the query, to be able to understand where the problem is, and how it may be addressed.” Read Jonathan’s interesting article: An example of making sensible guesses from a tkprof output.

Filed in Oracle on 24 Apr 06 | Tags: , ,

Reader's Comments

  1. |

    very interesting Eddie! Karl

  2. |

    Yes, Karl. It’s always enlightening to learn how smart Oracle experts, like Jonathan, think.