performance [message #635526] |
Tue, 31 March 2015 08:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a97766869295c236392b01429bc9e00c?s=64&d=mm&r=g) |
rameshk0316@gmail.com
Messages: 9 Registered: March 2015 Location: chennai
|
Junior Member |
|
|
SELECT n.username,
2 s.sid,
3 s.value
4 FROM v$sesstat s,v$statname t, v$session n
5 WHERE s.statistic# = t.statistic#
6 AND n.sid = s.sid
7 AND t.name='CPU used by this session'
8 ORDER BY s.value desc;
USERNAME SID VALUE
---------------------------- -----
JOHLMAN 152 20745
NROBERTS 103 4944
JOHLMAN 167 4330
LROLLINS 87 3699
JENGMAN 130 3694
JPATEL 66 3344
NALAPATI 73 3286
Hi, above query is high cpu users.
please let me know how to compare the values in value column eg: johlman is 20745.
what is the target value. i did not understand values.
please explain how to compare the values.
regards
Ramesh T
|
|
|
|
|
Re: performance [message #635530 is a reply to message #635526] |
Tue, 31 March 2015 08:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Lalit Kumar B wrote on Tue, 31 March 2015 12:14Hi Ramesh,
Welcome to the forum!
Please read and follow the OraFAQ Forum Guide
See if this link is useful.
Your answer:
rameshk0316@gmail.com wrote on Tue, 31 March 2015 12:47ok sure. Thank u very much for rapid repose
In your next topic:
John Watson wrote on Tue, 31 March 2015 13:03Ramesh, plese read the guidelines to which Lalit directed you....
So once more:
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals.
[Updated on: Tue, 31 March 2015 08:57] Report message to a moderator
|
|
|