select
ss.username,
ss.serial#,
se.SID,
VALUE/100 cpu_usage_seconds
from
v$session ss,
v$sesstat se,
v$statname sn
where
se.STATISTIC# = sn.STATISTIC#
and
NAME like '%CPU used by this session%'
and
se.SID = ss.SID
and
ss.status='ACTIVE'
and
ss.username is not null
order by VALUE desc;
Please feel free to correct me if there are any errors in the blog. I am writing this blog for my reference and understanding.
Monday, 17 July 2017
Subscribe to:
Post Comments (Atom)
Jenkins Startup and Configuration
Steps to setup jenkins on ubuntu:- -After installation. check the jenkins services running on not on the server. sudo service jenk...
-
Oracle 11g Hidden Database Parameters ============================= [oracle@dev ~]$ sqlplus / as sysdba; SQL*Plus: Release 11.2.0.3.0 Prod...
-
Softwares Required to install WebLogic Server: 1. jdk-8u121-windows-x64.exe (for development) or jrockit-jdk1.6.0_45-R28.2.7-4.1.0-w...
-
Docker Installation on AWS EC2 ``` sudo apt install docker.io sudo systemctl enable --now docker docker -v ``` Other way to Install...
No comments:
Post a Comment