oracle 12 跟踪,Oracle 12C R2-新特性-跟踪索引使用情况

Oracle 12C R2-新特性-跟踪索引使用情况

https://www.cndba.cn/Expect-le/article/1770https://www.cndba.cn/Expect-le/article/1770https://www.cndba.cn/Expect-le/article/1770

12.2中新增了新的视图V$INDEX_USAGE_INFO，提供索引在数据库中使用的情况。从而可以看出索引是否被使用以及使用率。这些信息有助于评估索引的策略。

SQL> desc V$INDEX_USAGE_INFO

Name Null? Type

----------------------------------------- -------- ----------------------------

INDEX_STATS_ENABLED NUMBER

INDEX_STATS_COLLECTION_TYPE NUMBER

ACTIVE_ELEM_COUNT NUMBER

ALLOC_ELEM_COUNT NUMBER

MAX_ELEM_COUNT NUMBER

FLUSH_COUNT NUMBER

TOTAL_FLUSH_DURATION NUMBER

LAST_FLUSH_TIME TIMESTAMP(3)

STATUS_MSG VARCHAR2(256)

CON_ID NUMBER

SQL> select INDEX_STATS_ENABLED,ACTIVE_ELEM_COUNT,CON_ID FROM V$INDEX_USAGE_INFO;

INDEX_STATS_ENABLED ACTIVE_ELEM_COUNT CON_ID

------------------- ----------------- ----------

1 0 1

NDEX_STATS_ENABLED：0: Index statistics are disabled 1: Index statistics are enabled

https://www.cndba.cn/Expect-le/article/1770https://www.cndba.cn/Expect-le/article/1770

更多信息参考官方文档：

https://www.cndba.cn/Expect-le/article/1770https://www.cndba.cn/Expect-le/article/1770

https://www.cndba.cn/Expect-le/article/1770

https://www.cndba.cn/Expect-le/article/1770

版权声明：本文为博主原创文章，未经博主允许不得转载。

索引使用情况