Re: Top Sessions
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 03 Mar 2001 09:24:10 -0800
Message-ID: <3AA128BA.21DC105_at_exesolutions.com>
Date: Sat, 03 Mar 2001 09:24:10 -0800
Message-ID: <3AA128BA.21DC105_at_exesolutions.com>
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
Received on Sat Mar 03 2001 - 18:24:10 CET