Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the 10 worst performing SQL statements?

Re: How to find the 10 worst performing SQL statements?

From: Joshua Goodstein <awing_pilot_at_yahoo.com>
Date: 23 Aug 2001 18:56:00 -0700
Message-ID: <924a90f8.0108231756.54993d8c@posting.google.com> 





try bmark.sql. It was written by mark gurry and shows all the stats
you want to see. I got a copy out of the Tuninug book from oreilly.



Joshua Goodstein



Oracle DBA





parker_at_indiamail.com (Joe Bo) wrote in message news:<a8cf5098.0108230934.d7a1c73_at_posting.google.com>...


> Do home work on v$sqlarea, v$sql, and v$sqltext, that will answer your concerns.

Received on Thu Aug 23 2001 - 20:56:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US