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: Andy <enzoweb_at_hotmail.com>
Date: 22 Aug 2001 20:25:19 -0700
Message-ID: <8d4033cd.0108221925.27732bca@posting.google.com> 





Many thanks to all the respondees, I am looking at the v$sqlarea
stuff.



Why am I not using Statspack? Because it's a Production system with
tight change control, and although I can run SQL Statments against it,
the Manager has not given me permission to install the Statspack
procedures without going through Change control (a week's wait) and he
wants the info now. As usual.



I understand that the results may not be 100% accurate, but at least
I'lll have a pretty report to show him.



Thanks,



Andy
Received on Wed Aug 22 2001 - 22:25:19 CDT












Original text of this message













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