Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I get a list of most resource consuming SQL statements
Use Perfomance Pack, which is a product of Oracle 8.x shows you exactly all
types of graphical representation of I/O, CPU ....usages.
Thanks,
Vrajesh.
Cor Kooij wrote:
> I'm looking for a way to find out which SQL-statements consumed the most
> resources in terms of CPU and/or memory, the last hours/day/week.
> A top 10 or whatever number of SQL-statements would enable me to focus
> on the worst cases first.
Received on Mon Apr 19 1999 - 12:03:26 CDT