Re: CPU - times

From: Roger Roach <pwrpln_at_bellsouth.net>
Date: 1997/03/15
Message-ID: <01bc30fa$8775c1d0$db0335cf@rkr>#1/1

Detlev Windmeier <Detlev.Windmeier_at_t-online.de> wrote in article <5g1avc$7qu_at_news00.btx.dtag.de>...
> Does anyone know how to audit CPU-Times a USER take ? Is there perhaps a
tool to
> get this information.
>
> Please tell me any idea you have.
> Greetings Detlev
>
> \\ Detlev Windmeier
> \\ Vatter GmbH Rheine, Germany
> \\
> \\ dwindmei_at_saralee.com
>
>
>

Try this ....

SELECT v$statname.name,v$sesstat.value

FROM v$statname ,

          v$sesstat,
          v$session
   WHERE  v$statname.statistic# = v$sesstat.statistic#  and
          v$statname.statistic# = 12 and
          v$session.user# = uid and 
          v$sesstat.sid = v$session.sid;

Good Luck..... Received on Sat Mar 15 1997 - 00:00:00 CST