ORACLE TUNING
孙海龙_1982
这个作者很懒,什么都没留下…
展开
-
Oracle optimizer_index_cost_adj and SQL Performance
As you may know, Oracle provides several parameters that can adjust the behavior of the CBO to change the internal costing for different types of operations: optimizer_index_cachingoptimizer转载 2013-06-11 15:46:28 · 1126 阅读 · 0 评论 -
optimizer_index_caching Tips
The optimizer_index_caching parameter tell the optimizer how much of an index (on average) in in the the RAM data buffer). Specifically, theoptimizer_index_caching parameter is used when determining转载 2013-06-11 15:12:09 · 439 阅读 · 0 评论 -
WAITEVENT: "PX Deq: Signal ACK" (文档 ID 257594.1)
"PX Deq: Signal ACK" Reference NoteThis is a reference note for the wait event "PX Deq: Signal ACK" which includes the following subsections:Brief definitionIndividual wait details (eg: For wait转载 2014-06-26 10:55:53 · 400 阅读 · 0 评论