Re: Track user resource usage

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 27 Feb 2004 23:01:32 +0100
Message-ID: <sffv30d6feib73cuc0up6anu6pkm9nkl7m@4ax.com>

On 27 Feb 2004 12:14:09 -0800, raj_from_to_at_yahoo.com (raj) wrote:

>Hi,
>
>I would like to track the resource usage (such as CPU) of the users. However,
>V$SESSION contains data only while the sessions are active. Is there another
>table which contains total user resource usage similar to V$SESSION?
>
>Any other method you can think of in addition to triggers?
>
>Any help is appreciated.
>
>Raj

You can't put triggers on any v$ table.
Audit connect would work (keeps track of resource consumption) as would using statspack provided you track session info.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Feb 27 2004 - 16:01:32 CST