概述

今天主要分享3個實用腳本，顯示Oracle數據庫活動會話及查看其中的活動會話和對象正在被哪個會話使用。

1、Lists all objects being accessed in the schema.

SELECT a.object, a.type, a.sid, b.serial#, b.username, b.osuser, b.program
 FROM v$access a, v$session b
 WHERE a.sid = b.sid
 AND a.owner = 'RFUSER'

2、 Displays information on all active database sessions.

SELECT NVL(s.username, '(oracle)') AS username,
 s.osuser,
 s.sid,
 s.serial#,
 p.spid,
 s.lockwait,
 s.status,
 s.machine,
 s.program,
 TO_CHAR(s.logon_Time, 'DD-MON-YYYY HH24:MI:SS') AS logon_time,
 s.last_call_et AS last_call_et_secs,
 s.module,
 s.action,
 s.client_info,
 s.client_identifier
 FROM v$session s, v$process p
 WHERE s.paddr = p.addr
 AND s.status = 'ACTIVE'
 ORDER BY s.username, s.osuser;

3、Displays information on all active database sessions.

覺得有用的朋友多幫忙轉發哦！後面會分享更多devops和DBA方面的內容，感興趣的朋友可以關注下~