Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    9

    Unanswered: TOP SQL - CHeck own statements

    hello,

    I want to use the Oracle TOP SQL analyser, but its not possible to edit the listet sql statements. Only the statements, executet in the past, are listet to analyse. But whats with new SQLs with checking at development ??

    help thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Not sure what you are looking for ...

    If you are in a development mode and want to analyze your sql ...
    Use SQLPlus, turn on autotrace and check the explain plan...
    Are you looking to see how much disk io a query is causing ?
    Are you looking to see the most CPU expensive sql you have ?

    Give a little more detail and let's see what we can do to help

    Gregg

Posting Permissions

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