HomeSearchE-MailPrint
French English Chinese

CPU usage by session

How to obtain a list of the opened sessions, as well as the utilisation ratio of the processor for each session. Indeed, it can be interesting to be able to post this information.

Votes: 9

Comments: 0

Visits: 2377

Administration 28-JUN-2004 10:53 AM, Reda Benkirane

This statement gives the utilisation ratio of the processor by session.
To obtain this information, it is enough for you to login as SYSDBA and execute the following statement:

select ses.SID,
nvl(ses.USERNAME,'ORACLE PROC') username, p.SPID,
sn.NAME statistic,
sest.VALUE
from v$session ses,
v$statname sn,
v$process p,
v$sesstat sest
where ses.SID = sest.SID
and sn.STATISTIC# = sest.STATISTIC#
and sest.VALUE is not null
and sest.VALUE != 0
and upper(sn. NAME) LIKE upper('cpu used by %')
and ses.PADDR=p.ADDR
order by sest.VALUE
Next Previous

Comments

Login to leave a comment.

Articles

Oracle Installation on SUSE Linux Enterprise Server

Administration 14-JUN-2008 07:03 PM, Fabien Loudet

We will follow step-by-step the installation of Oracle Database 10g on SUSE Linux Enterprise Server. We choose here to install Oracle Enterprise Edition and create a database.

More Articles
Articles RSS
Source Codes

Add Multi-language support

Portal 25-NOV-2004 10:30 AM, Pierre-Henry Tupin

Instant Messenger

Communication 24-NOV-2004 10:31 AM, Arnaud Bontemps

Who is online

Portal 24-NOV-2004 10:26 AM, Arnaud Bontemps

Change the Portal CSS

Portal 15-JUN-2004 04:15 PM, Arnaud Bontemps, Yoan Sultan

More Source Codes
Source Codes RSS
News

Oracle VM Templates

02-SEP-2008 12:15 PM, Jérémie Hodnik

Further enabling customers to benefit from server consolidation, energy and space cost savings by using enterprise-class server virtualization, Oracle today announced Oracle® VM Templates.

Oracle Unbreakable Linux

02-SEP-2008 12:08 PM, Thibaut Maxant

Oracle's Linux commitment began in 1998 with the first commercial database on Linux.

Oracle's Industry Strategy

01-SEP-2008 12:01 PM, Thibaut Maxant

Oracle is the #1 in Relational Database

20-AUG-2008 07:26 PM, Thibaut Maxant

Gartner 2007 Worldwide RDBMS Market Share Reports 48.6% Share for Oracle.

Oracle Buys Skywire Software

02-AUG-2008 11:18 AM, Zhen Dong

June 23, 2008, Oracle announced that it has reached an agreement with Skywire Software and buys of its business application software.

More News
News RSS