Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how much CPU is used by session
On 26 Apr, 23:46, sybra..._at_hccnet.nl wrote:
> On Thu, 26 Apr 2007 20:57:55 +0200, Andrea <n..._at_tin.it> wrote:
> >Hi,
> >on my 8.1.7 Oracle DB i found my CPU highest then normal, reaching often
> >50%/60% without any important transaction.
> >I would like to know if is possible how much CPU is used by particular
> >session, there is some performance view where i can found CPU usage for each
> >session?
> >Or i have to install statspack mandatory?
>
> >thanks for support.
>
> >bye
> >Andrew
>
> That would be v$sesstat.
> Nobody should do without statspack, but statspack doesn't track
> session data.
> You could set up a before logoff on database trigger copying the
> results from v$sesstat in a ordinary table.
>
ok, so with this select i can find CPU session status in really time (sid 19 is my session):
SELECT SID,VALUE FROM V$SESSTAT WHERE SID='19' AND STATISTIC# = '12';
correct?
without any statspack or timed_statistics active?
thanks very much Received on Fri Apr 27 2007 - 03:02:48 CDT