Oracle 19c 新特性详解：自动索引（Automatic Indexing）的输出报告范例

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Oracle 19c 新特性详解：自动索引（Automatic Indexing）的输出报告范例，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2087字，纯文字阅读大概需要3分钟。

内容图文

Oracle 19c 新特性详解：自动索引（Automatic Indexing）的输出报告范例

发布时间：2019-02-21?发布人：老张拉呱

PDB1@ZRP>set serveroutput on 
PDB1@ZRP>declare 
2 report clob := null; 
3 begin 
4 report := DBMS_AUTO_INDEX.REPORT_ACTIVITY( 
5 activity_start => TO_TIMESTAMP('2019-02-17 22:51:00', 'yyyy-mm-dd hh24:mi:ss'), 
6 activity_end => TO_TIMESTAMP('2019-02-17 22:53:07', 'yyyy-mm-dd hh24:mi:ss'), 
7 type => 'HTML', 
8 section => 'ALL', 
9 level => 'ALL'); 
10 dbms_output.put_line(report); 
11 end; 
12 /

general information

Activity start

Activity end

Executions completed

Executions interrupted

Executions with fatal error

: 17-FEB-2019 22:51:00

: 17-FEB-2019 22:53:07

: 1

: 0

: 0

summary (auto indexes)

Index candidates

Indexes created (visible / invisible)

Space used (visible / invisible)

Indexes dropped

SQL statements verified

SQL statements improved (improvement factor)

SQL plan baselines created

Overall improvement factor

: 1

: 1 (1 / 0)

: 45.09_MB (45.09_MB / 0_B)

: 0

: 2

: 2 (44948.5x)

: 0

: 44948.5x

summary (manual indexes)

Unused indexes

Space used

Unusable indexes

: 0

: 0_B

: 0

index details

1. The following indexes were created:
*: invisible

verification details

1. The performance of the following statements improved:

Parsing Schema Name

SQL ID

SQL Text

Improvement Factor

: ZRP

: 6664xv8fak0q5

: select sharded from test where object_id=123456

: 44919x

plans section

- Original

Plan Hash Value

: 1357081020

Notes

- optimizer_use_stats_on_conventional_dml = yes 
- With Auto Indexes

Plan Hash Value

: 159453698

Predicate Information (identified by operation id):

• 2 - access("OBJECT_ID"=123456)

Notes

- Dynamic sampling used for this statement ( level = 11 ) 

Parsing Schema Name

SQL ID

SQL Text

Improvement Factor

: ZRP

: 6d4vdmp6hq73p

: select created from test where object_id=234

: 44978x

plans section

- Original

Plan Hash Value

: 1357081020

Notes

- optimizer_use_stats_on_conventional_dml = yes 
- With Auto Indexes

Plan Hash Value

: 159453698

Predicate Information (identified by operation id):

• 2 - access("OBJECT_ID"=234)

Notes

- Dynamic sampling used for this statement ( level = 11 ) 

errors

No errors found.

PL/SQL procedure successfully completed.

PDB1@ZRP>spool off

内容总结

以上是互联网集市为您收集整理的Oracle 19c 新特性详解：自动索引（Automatic Indexing）的输出报告范例全部内容，希望文章能够帮你解决Oracle 19c 新特性详解：自动索引（Automatic Indexing）的输出报告范例所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---