- 博客(6)
- 资源 (6)
- 收藏
- 关注
转载 dba_source存储的内容解释
什么是dba_source字典视图: 存储所有函数、过程、程序包和Java源的完整的文本,对于你了解一个数据库对象的源代码很有用。存储过程在该视图中是以行为单位进行存储的。dba_source视图中存储的是行为单位拆分的存储过程等对象如下找到的内容:select * from dba_source where name='SQLPROF_ATTR' and owner='SYS'; owner
2017-03-25 10:19:24 6849
转载 sql bind capture相关文档
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
2017-03-21 14:46:10 374
原创 dba_outlines里的signature理解
官方文档里的解释:SIGNATURE RAW(16) Signature uniquely identifying theoutline SQL text在11.2.0.4里测试,该signature是忽略sql的大小写及每个单词之间多余的空格。(测试方式如下:SQL> alter session set create_stored_outlines =test;SQL> s
2017-03-11 11:06:22 619
转载 How do adaptive cursor sharing and SQL Plan Management interact?
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
2017-03-01 16:39:30 454
转载 How do I force a query to use bind-aware cursor sharing?
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
2017-03-01 16:37:19 525
转载 Oracle 11g 针对SQL性能的新特性(一)- Adaptive Cursor Sharing
Oracle 11g 针对SQL性能的新特性(一)- Adaptive Cursor Sharing By Roger Song-Oracle on 十月 03, 2011 Oracle 11g对SQL执行计划的生成过程做了很多改变,我们经常看到有客户抱怨,数据库在升级到11g以后,执行计划变得很不稳定,甚至难以预测。实际上,Oracle在最新版本中致力于让优化器变得
2017-03-01 16:33:44 442
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人