1 2 Previous Next 17 Replies Latest reply: Oct 13, 2010 2:00 PM by marlborocat RSS

    how to get top CPU consuming sql oracle 10g

    marlborocat
      I can see the top sql by running ASH report. but there is too much infomation. is there a way I can just display TOP SQL section, and filter out other parts? this way I can use it in a shell script, and loop through the database.

      or is there a query can do the ASH job?

      thanks.

      Karl
        1 2 Previous Next