Re: Slowest running Database routine

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 10 May 2006 10:02:50 -0700
Message-ID: <1147280570.464884@bubbleator.drizzle.com>

Pratap wrote:
> Hi All
> can anybody suggest me how to find slowest running procedures/functions
> (like Top 10) in an application using Oracle 9i Database?
>
> Thanks in Advance,
> Pratap

Define slowest running.

Time from start to completion?
CPU time?
Disk i/o?

Either way ... StatsPack.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed May 10 2006 - 12:02:50 CDT