`
mathfox
  • 浏览: 35320 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

Oracle Execution Plans

阅读更多

Obtaining Execution Plans

  • Execute the SQL statement EXPLAIN PLAN,and then query the table where the output was written.
  • Query a dynamic performance view showing the execution plans cached in the library cache.
  • Query an Automatic Workload Repository or Statspack table, showing the execution plans stored in the repository.
  • Activate a tracing facility providing execution plans.

plan_table Position : $ORACLE_HOME/rdbms/admin/ultxplan.sql

 

 

  • 大小: 47.9 KB
  • 大小: 99.9 KB
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics