Home » RDBMS Server » Performance Tuning » performance
performance [message #635526] Tue, 31 March 2015 08:36 Go to next message
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 #635527 is a reply to message #635526] Tue, 31 March 2015 08:39 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Check this out https://docs.oracle.com/database/121/REFRN/stats002.htm#i375475
Re: performance [message #635529 is a reply to message #635527] Tue, 31 March 2015 08:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What problem are you trying to solve?

How will you or I know when this problem has been solved?

>please explain how to compare the values.
larger value means more CPU time was consumed.
Keep in mind that CPU cycles are REQUIRED to process every SQL statement.
There Is No Such Thing As A Free Lunch.
Re: performance [message #635530 is a reply to message #635526] Tue, 31 March 2015 08:57 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Lalit Kumar B wrote on Tue, 31 March 2015 12:14
Hi 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:47
ok sure. Thank u very much for rapid repose


In your next topic:

John Watson wrote on Tue, 31 March 2015 13:03
Ramesh, 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

Previous Topic: ORA-00439: feature not enabled: Bit-mapped indexes
Next Topic: performance
Goto Forum:
  


Current Time: Thu Mar 28 21:32:34 CDT 2024