{"id":1803,"date":"2020-08-25T16:28:33","date_gmt":"2020-08-25T08:28:33","guid":{"rendered":"http:\/\/www.llku.com\/?p=1803"},"modified":"2020-08-25T16:28:33","modified_gmt":"2020-08-25T08:28:33","slug":"oracle%e4%bc%98%e5%8c%96%e6%9f%a5%e8%af%a2%e8%b5%84%e6%ba%90%e6%b6%88%e8%80%97%e7%9a%84%e8%af%ad%e5%8f%a5","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1803","title":{"rendered":"ORACLE\u4f18\u5316\u67e5\u8be2\u8d44\u6e90\u6d88\u8017\u7684\u8bed\u53e5"},"content":{"rendered":"

1\u3001SQL ordered by Gets
\nselect *
\nfrom (select substr(sql_text, 1, 40) sql,
\nbuffer_gets,
\nexecutions,
\nbuffer_gets \/ executions “Gets\/Exec”,
\nhash_value,
\naddress
\nfrom v$sqlarea
\nwhere buffer_gets > 0
\nand executions > 0
\norder by buffer_gets desc)
\nwhere rownum <= 10;<\/p>\n

2\u3001SQL ordered by Reads
\nselect *
\nfrom (select substr(sql_text, 1, 40) sql,
\ndisk_reads,
\nexecutions,
\ndisk_reads \/ executions “Reads\/Exec”,
\nhash_value,
\naddress
\nfrom v$sqlarea
\nwhere disk_reads > 0
\nand executions > 0
\norder by disk_reads desc)
\nwhere rownum <= 10;<\/p>\n

3\u3001SQL ordered by Executions
\nselect *
\nfrom (select substr(sql_text, 1, 40) sql,
\nexecutions,
\nrows_processed,
\nrows_processed \/ executions “Rows\/Exec”,
\nhash_value,
\naddress
\nfrom v$sqlarea
\nwhere executions > 0
\norder by executions desc)
\nwhere rownum <= 10;<\/p>\n

4\u3001SQL ordered by Parse Calls
\nselect *
\nfrom (select substr(sql_text, 1, 40) sql,
\nparse_calls,
\nexecutions,
\nhash_value,
\naddress
\nfrom v$sqlarea
\nwhere parse_calls > 0
\norder by parse_calls desc)
\nwhere rownum <= 10;<\/p>\n

5\u3001Running Time top 10 sql
\nselect *
\nfrom (select t.sql_fulltext,
\n(t.last_active_time –
\nto_date(t.first_load_time, \u2018yyyy – mm – dd hh24 :mi :ss\u2018)) * 24 * 60,
\ndisk_reads,
\nbuffer_gets,
\nrows_processed,
\nt.last_active_time,
\nt.last_load_time,
\nt.first_load_time
\nfrom v$sqlarea t
\norder by t.first_load_time desc)
\nwhere rownum < 10;<\/p>\n","protected":false},"excerpt":{"rendered":"