From: "Daniel A. Morgan" <dmorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Top Sessions
Date: Sat, 03 Mar 2001 09:24:10 -0800
Organization: EXE
Message-ID: <3AA128BA.21DC105@exesolutions.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
References: <0Utn6.135476$Z2.1831432@nnrp1.uunet.ca>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yabetcha.drizzle.com!unknown@win30.drizzle.com
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
X-Complaints-To: newsabuse@supernews.com
Lines: 23


Perform the following query:

select object_name
from dba_objects
where object_name like 'V%STAT%';

You will find lots material to work with.

Daniel A. Morgan



Raj wrote:

> I am fairly new to Oracle and would like to know how to determine which
> sessions are consuming the most amount of resources.
> Does anybody have any handy scripts?
> What information should I be looking for?
>
> Any help is highly appreciated.
>
> Raj