Re: Top N queries
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: rachidtamba@xxxxxxxxxxx
- Date: Mon, 6 Mar 2006 19:54:42 -0800
collectings statspack statistics
and running the statspack reports
is a pretty easy way to do this.
See $ORACLE_HOME/rdbms/admin/spdoc.txt for instructions.
Or google for it.
Jared
On 3/6/06, RACHID TAMBA <rachidtamba@xxxxxxxxxxx> wrote:
>
> Hi All :
>
> Any one has an idea how to write a script ( on UNIX ) to find out the top
> N
> queries which are consuming a lot of resources ?
>
> Thank you.
>
> _________________________________________________________________
> Take charge with a pop-up guard built on patented Microsoft(r) SmartScreen
> Technology.
>
> http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
> Start enjoying all the benefits of MSN(r) Premium right now and get the
> first two months FREE*.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
