执行explain plan for statement 可以在session级别更改，如：ALTER SESSION SET OPTIMIZER_MODE = FIRST_ROWS_1; ..
基于4个网页-相关网页
The SQL explain facility provides detailed information about the access plan that the query optimizer chooses for an SQL statement.
SQL 解释工具提供查询优化器为 SQL 语句所选择的访问计划的有关详细信息。
It reads the SQL statements executed from the event monitor tables and runs the Explain utility for each statement to generate the corresponding access plan.
它将读取从事件监控器表执行的sql语句，然后对每个语句运行Explain实用程序以生成对应的访问计划。
应用推荐