2014年
-
编辑 删除
Top 10 Sql (DBA 调优参考)
--sqlareaselect * from v$sqlarea vswhere 1=1 and vs.HASH_VALUE = '2692618562';--Top 10 by Buffer Gets:SELECT * FROM(SELECT substr(sql_text,1,50) sql,sql_text, buffer_gets, executions, buffer_gets/executions "Gets/Exec",s.CPU_...
