Shulou(Shulou.com)06/01 Report--

A total of three step

Step1: add hint: / * + gather_plan_statistics*/ when sql is executed

Step2: find out the sql id of sql: select * from v$sql 's where s.SQL_TEXT like 'SELECT / * + monitor*/TT.*%'

Step3: execute the following sql to view the real execution plan

SELECT

Sp.last_starts AS "starts"

Sp.last_output_rows AS "rows"

Round (sp.last_elapsed_time / 1000000, 2) AS TIME

Sp.last_cr_buffer_gets bf

Sp.depth d

Rtrim (lpad ('', 2 * (depth-1)) | | operation | |

Decode (options, NULL,'',''| | options)) "Explain plan"

Decode (id

0

'-'

Substr (decode (substr (object_name, 1,7))

'SYS_LE_'

NULL

Object_name) | |''

one,

30) AS "object"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.