久久精品国产91精品亚洲_欧美日韩性视频在线_欧美私人啪啪vps_亚洲精品乱码久久久久久按摩观_99热这里只有精品8_黑丝一区二区三区_国产美女精品免费电影_亚洲图片在线观看_久久不见久久见免费视频1_亚洲欧美在线免费观看_欧美一区二区私人影院日本_国产精品美女视频网站_一区二区三区精品国产_亚洲美女免费精品视频在线观看_国产午夜精品久久_久久国产精品久久久久久久久久

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;