WAITEVENT: "latch: row cache objects" Reference Note (Doc ID 1550722.1)
latch: row cache objects" Reference NoteThis is a reference note for the wait event "latch: row cache objects" which includes the following subsections:Brief definition Individual wait details (eg: For waits seen in <<View:V$SESSION_WAIT>>) Systemwide wait details (eg: For w...
WAITEVENT: "row cache lock" Reference Note (文档 ID 34609.1)
row cache lock Reference NoteThis is a reference note for the wait event "row cache lock" which includes the following subsections:Brief definition Individual wait details (eg: For waits seen in V$SESSION_WAIT) Systemwide wait details (eg: For waits seen in V$SYSTEM_EVENT) ...
为何在查询中索引未被使用 (文档 ID 1549181.1)
为何在查询中索引未被使用 (文档 ID 1549181.1)转到底部文档内容...
FAQ: Row Movement Common Questions and Problems on Partitioned Tables
FAQ: Row Movement Common Questions and Problems on Partitioned Tables (文档 ID 1518567.1)Applies to:Oracle Database - Enterprise Edition - Version 8.1.6.0 and laterInformation in this document applies to any platform.PurposeThis FAQ documents answers some of the common questions and ...
研究 b-tree 索引结构的脚本 (文档 ID 1577374.1)
适用于:Oracle Database - Enterprise Edition - 版本 9.0.1.0 到 11.2.0.4 [发行版 9.0.1 到 11.2]本文档所含信息适用于所有平台用途这个脚本将根据已存在的表和索引的统计信息来核实b-tree索引结构。这个脚本将计算如下的条目:- 估计索引的理论大小。- 索引布局这个脚本会将收集的信息以历史记...