識別低效執行的SQL語句

LuiseDalian發表於2014-01-14

點選(此處)摺疊或開啟

  1. --識別低效的SQL語句
  2. SELECT executions, disk_reads, buffer_gets,
  3. ROUND((buffer_gets-disk_reads)/buffer_gets, 2) hit_ration,
  4. ROUND(disk_reads/executions, 2) READS_per_run, SQL_text
  5. FROM v$sqlarea
  6. WHERE executions > 0 AND buffer_gets > 0 AND (buffer_gets -disk_reads)/buffer_gets < 0.8
  7. AND parsing_schema_name = \'SCOTT\'
  8. ORDER BY 4 DESC;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1070478/,如需轉載,請註明出處,否則將追究法律責任。

相關文章