Session Statistics--Session I/O By User
来源:互联网 发布:linux操作系统教程pdf 编辑:程序博客网 时间:2024/05/22 06:29
Session Statistics
Here are some scripts related to Session Statistics .
Session I/O By User
SESSION I/O BY USER NOTES:
selectnvl(ses.USERNAME,'ORACLE PROC') username,OSUSER os_user,PROCESS pid,ses.SID sid,SERIAL#,PHYSICAL_READS,BLOCK_GETS,CONSISTENT_GETS,BLOCK_CHANGES,CONSISTENT_CHANGESfromv$session ses, v$sess_io siowhere ses.SID = sio.SIDorder by PHYSICAL_READS, ses.USERNAME
CPU Usage By Session
CPU USAGE BY SESSION NOTES:
select nvl(ss.USERNAME,'ORACLE PROC') username,se.SID,VALUE cpu_usagefrom v$session ss, v$sesstat se, v$statname snwhere se.STATISTIC# = sn.STATISTIC#and NAME like '%CPU used by this session%'and se.SID = ss.SIDorder by VALUE desc
Resource Usage By User
RESOURCE USAGE BY USER NOTES:
select ses.SID,nvl(ses.USERNAME,'ORACLE PROC') username,sn.NAME statistic,sest.VALUEfrom v$session ses, v$statname sn, v$sesstat sestwhere ses.SID = sest.SIDand sn.STATISTIC# = sest.STATISTIC#and sest.VALUE is not nulland sest.VALUE != 0 order by ses.USERNAME, ses.SID, sn.NAME
Session Stats By Session
SESSION STAT NOTES:
select nvl(ss.USERNAME,'ORACLE PROC') username,se.SID,sn.NAME stastic,VALUE usagefrom v$session ss, v$sesstat se, v$statname snwhere se.STATISTIC# = sn.STATISTIC#and se.SID = ss.SIDandse.VALUE > 0order by sn.NAME, se.SID, se.VALUE desc
Cursor Usage By Session
CURSOR USAGE BY SESSION NOTES:
select user_process username,"Recursive Calls","Opened Cursors","Current Cursors"from (select nvl(ss.USERNAME,'ORACLE PROC')||'('||se.sid||') ' user_process, sum(decode(NAME,'recursive calls',value)) "Recursive Calls",sum(decode(NAME,'opened cursors cumulative',value)) "Opened Cursors",sum(decode(NAME,'opened cursors current',value)) "Current Cursors"from v$session ss, v$sesstat se, v$statname snwhere se.STATISTIC# = sn.STATISTIC#and (NAME like '%opened cursors current%'or NAME like '%recursive calls%'or NAME like '%opened cursors cumulative%')and se.SID = ss.SIDand ss.USERNAME is not nullgroup by nvl(ss.USERNAME,'ORACLE PROC')||'('||se.SID||') ')orasnap_user_cursorsorder by USER_PROCESS,"Recursive Calls"
User Hit Ratios
USER HIT RATIO NOTES:
selectUSERNAME,CONSISTENT_GETS, BLOCK_GETS, PHYSICAL_READS, ((CONSISTENT_GETS+BLOCK_GETS-PHYSICAL_READS) / (CONSISTENT_GETS+BLOCK_GETS)) Ratiofrom v$session, v$sess_iowhere v$session.SID = v$sess_io.SIDand (CONSISTENT_GETS+BLOCK_GETS) > 0and USERNAME is not nullorderby ((CONSISTENT_GETS+BLOCK_GETS-PHYSICAL_READS) / (CONSISTENT_GETS+BLOCK_GETS))
- Session Statistics--Session I/O By User
- User Session Filter实现
- 总结session.save(user)
- SESN0008E: A user authenticated as anonymous has attempted to access a session owned by user
- Oracle AWR Reports: Understanding I/O Statistics
- read by other session
- read by other session
- read by other session
- PHP5 Session 浅析I
- PHP5 Session 浅析I
- Oracle query user session id
- iOS录音错误:Deactivating an audio session that has running I/O
- Used DBMS_STATS.GATHER_TABLE_STATS to gather statistics,but the session hung.
- CPU used by this session
- OCP-042 AUDIT BY SESSION
- read by other session.sql
- 保护vnc session (by quqi99)
- Session
- JFreeChart对象的一般基本方法
- 基于cisco路由器的电话欢迎词制作方法
- 最近在看数据结构,第二章有点头大了
- 关于纸版INTEL MANUAL
- 动态链接库中分配内存引起的问题(转)
- Session Statistics--Session I/O By User
- 获取远程客户端的真实IP地址
- ibatis配置文件参数说明
- C++构造函数调用其他构造函数
- Materialized Views in Oracle--Oracle的物化视图
- ASP中使用XMLHTTP或ServerXMLHTTP读取远程数据
- 收藏一些优秀网址
- 濮阳人吕不韦(战国策)
- 关于书籍的选择——写给想成为Web开发程序员的一封信3