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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Top N queries

Re: Top N queries

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 6 Mar 2006 19:54:42 -0800
Message-ID: <bf46380603061954p31a374a1x32160fadd6543c17@mail.gmail.com>


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_at_hotmail.com> 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*.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 06 2006 - 21:54:42 CST

Original text of this message

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