[Oracle Script] check active session
select count(*) count from v$session where status='ACTIVE';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-2141486/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [Oracle Script] check userOracle
- [Oracle Script] check latchOracle
- [Oracle Script] check lock infoOracle
- [Oracle Script] check Literal SQLOracleSQL
- [Oracle Script] check tablespace usage infoOracle
- [Oracle Script] check temp tablespace usageOracle
- [Oracle Script] check object count by userOracleObject
- [Oracle Script] check File I/OOracle
- Oracle kill session scriptOracleSession
- [Oracle Script] Undo Usage Per sessionOracleSession
- check ftp success scriptFTP
- script of check repair ASM DISKGROUPAIASM
- Active Session History (ASH)Session
- WRH$_ACTIVE_SESSION_HISTORYSession
- Active Session History ReportsSession
- ASH(Active Session History)——概述(1)!Session
- Script to Collect Data Guard Physical and Active Standby Diagnostic InformationORM
- Clean WRH$_ACTIVE_SESSION_HISTORY in SYSAUXSessionUX
- v$active_session_history檢視Session
- active session的準確定義!Session
- oracle scriptOracle
- Active Session History (ASH) performed an emergency flushSessionORM
- v$active_session_history檢視[轉]Session
- Script: To Display Active Transactions in Rollback Segments_1019467.6
- [Oracle Script] LockOracle
- Oracle Database ScriptOracleDatabase
- V$ACTIVE_SESSION_HISTORY檢視的使用Session
- Oracle Active database duplicationOracleDatabase
- [Oracle Script] Top sqlOracleSQL
- ORACLE常用Script(轉)Oracle
- ORACLE常用Script (轉)Oracle
- ORACLE 10g SYSAUX表空間快速增長之WRH$_ACTIVE_SESSION_HISTORY篇Oracle 10gUXSession
- Script to Check for Foreign Key Locking Issues [ID 1019527.6]
- 11g v$active_session_history的新增列Session
- 轉載--V$ACTIVE_SESSION_HISTORY檢視的使用Session
- 通過shell指令碼快速定位active session問題指令碼Session
- V$ACTIVE_SESSION_HISTORY 檢視中包含的資訊Session
- V$SESSION.STATUS='ACTIVE' AND WAIT_EVENT='Idle'SessionAI