网友一个查询dbms_medata.get_ddl 导出索引定义很慢

最新推荐文章于 2021-08-27 11:22:13 发布

desert_xu

最新推荐文章于 2021-08-27 11:22:13 发布

阅读量531

点赞数

分类专栏：性能优化 trubleshooting

本文链接：https://blog.csdn.net/xxjj2003/article/details/76228612

版权

性能优化同时被 2 个专栏收录

24 篇文章 0 订阅

订阅专栏

trubleshooting

17 篇文章 0 订阅

订阅专栏

某个oracle qq群里一个咨询查询索引ddl 定义很慢

********************************************************************************

SQL ID: 3v9mgpjqffrj0 Plan Hash: 2962139578

SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T',
   '7')), KU$.OBJ_NUM 
FROM
 SYS.KU$_INDEX_VIEW KU$ WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS,128)!=0 AND  
  KU$.SCHEMA_OBJ.NAME=:NAME1 AND  KU$.SCHEMA_OBJ.OWNER_NAME=:SCHEMA2


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.28       0.28          0       3892          0           0
Fetch        1      1.94       1.93          0     249677          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      2.22       2.22          0     253569          0           1

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS   (recursive depth: 1)
Number of plan statistics captured: 1

查询了MOS