Re: Userstatistics

From: Feher Lajos <feherl_at_finit.hu>
Date: Wed, 24 Nov 1999 10:29:08 +0100
Message-ID: <81gb0f$h5r$1@newsgate.elender.hu>

You must set timed_statistics init.ora parameter true for whole instance. Note: this will mean a small overhead, but if you not want monitor every session, you can set it session level.
So query v$sesstat view.
select value from v$sesstat a, v$statname b where a.statistic# = b.statistic#
and a.statistic#=12 -- this mean CPU time and a.sid = session_sid - from v$session you get result in hundred of seconds

Feher Lajos

thorsten2103_at_my-deja.com wrote in message <81bjb6$vg8$1_at_nnrp1.deja.com>...
>Please Help:
>
>it is possible to log the cpu-time per user ?
>If yes, how ?
>(we use Oracle8.0.5 on AIX)
>
>Thanks.
>
>Thorsten
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Nov 24 1999 - 03:29:08 CST