loryliu的专栏

Oracle 11g 针对SQL性能的新特性（一）- Adaptive Cursor Sharing     By Roger Song-Oracle on 十月 03, 2011    Oracle 11g对SQL执行计划的生成过程做了很多改变，我们经常看到有客户抱怨，数据库在升级到11g以后，执行计划变得很不稳定，甚至难以预测。实际上，Oracle在最新版本中致力于让优化器变得

How do I force a query to use bind-aware cursor sharing?     By Allison on Feb 13, 2012no_BIND_AWARE是恰恰相反的作用Way back in our original post on adaptive cursor sharing, a commenter asked if t

How do adaptive cursor sharing and SQL Plan Management interact?     By Allison on Feb 11, 2013We've received a lot of questions about how adaptive cursor sharing (ACS) and SQL plan management

How To Create a Database SQL Trace Based On Capture Bind Variable For A Session Alone (文档 ID 434437.1)Not Every Bind Values Captured in  v$sql_bind_capture (文档 ID 1370816.1)Using  DBMS_XPLAN.D