select u.username,u.account_status,u.created,u.expiry_date,u.default_tablespace,u.temporary_tablespace,
sum(decode(sid,null,0,1)) "current logon",sum(decode(status,null,0,'INACTIVE',0,1)) "current active",round(sum(sysdate-logon_time)*24*60*60 / sum(decode(sid,null,0,1)),0) "Avg logon time"
from gv$session s,dba_users u where s.user#(+)=u.user_id
group by u.username,u.account_status,u.created,u.expiry_date,u.default_tablespace,u.temporary_tablespace
sum(decode(sid,null,0,1)) "current logon",sum(decode(status,null,0,'INACTIVE',0,1)) "current active",round(sum(sysdate-logon_time)*24*60*60 / sum(decode(sid,null,0,1)),0) "Avg logon time"
from gv$session s,dba_users u where s.user#(+)=u.user_id
group by u.username,u.account_status,u.created,u.expiry_date,u.default_tablespace,u.temporary_tablespace
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24237320/viewspace-2143138/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- [Linux7] HA Package Yum源配置
- [ASM] ORA-15032 ORA-15260
- [RAC] Oracle11g RAC禁止DB自动启动
- [Oracle] Device Checks for ASM - This is a pre-check........
- [Linux7] Centos7 multipath 盘权限绑定.
- [Linux7] zabbix 3.2.11安装
- [Oracle] Error in invoking target 'agent nmhs' of makefile
- [Linux] 查看环境变量
- [HPUX] HP Unix server vg自动激活
- [HPUX] UX:vxfs mount: ERROR: V-3-21264
