Re: how much CPU is used by session

On Thu, 26 Apr 2007 20:57:55 +0200, Andrea <no_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.

-- 
Sybrand Bakker
Senior Oracle DBA