- 數據庫維護
-
1、當前數據庫各個終端連接數
SELECT "連接數","終端名稱"
FROM ( SELECT COUNT(TERMINAL) AS 連接數,
TERMINAL AS 終端名稱
FROM v$sessionGROUP BY TERMINAL
)
ORDER BY 連接數 DESC;
2、查詢性能最差的SQL
SELECTdisk_reads,executions,rows_processed,
first_load_time,sql_text
FROMsys.v_$sqlarea
WHEREdisk_reads >10
AND executions < 10
ORDER BYfirst_load_time;
3、找使用CPU多的用戶session
SELECT a.sid,spid,status,substr(a.program,1,40) prog,
a.terminal,osuser,value/60/100 value
FROM v$session a,v$process b,v$sesstat c
WHERE c.statistic#=12
AND c.sid=a.sid
AND a.paddr=b.addr
ORDER BY VALUE DESC;
4、當前各用戶運行什么SQL語句
SELECTosuser, username, sql_text
FROMv$session a, v$sqltext b
WHEREa.sql_address =b.address
ORDER BY address, piece;