| querying the highest CPU using user [message #62832] |
Wed, 18 August 2004 02:29  |
Devnarayan
Messages: 7
Registered: June 2004
|
Junior Member |
|
|
Is there any way to query which user of oracle is using the highest CPU resource. Is there any dynamic performance view available like v$session through which we can check which user/session is using the highest CPU usage.
Devnarayan
|
|
|
|
| Re: querying the highest CPU using user [message #62834 is a reply to message #62832] |
Wed, 18 August 2004 03:23  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Try this :
select sid,a.value from v$sesstat a, v$sysstat b
where a.statistic#=b.statistic# and
b.name='CPU used by this session';
The above query will show the amount of CPU time (in 10s of milliseconds) used by per session.
Daljit Singh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
