摘要:
SELECT EXECUTIONS, DISK_READS, BUFFER_GETS,ROUND((BUFFER_GETS-DISK_READS)/BUFFER_GETS, 2) Hit_radio,ROUND(DISK_READS/EXECUTIONS,2) Reads_per_mn,SQL_TEXTFROM V$SQLAREAWHERE EXECUTIONS> 0AND BUFFER_GETS> 0AND (BUFFER_GETS-DISK_READS)/BUFFER_GETS < 0.8ORDER BY 4 DESC;1:查看哪个session锁定临时表,表格对象. 这 阅读全文