dblink sdo_geometry_Oracle sdo_geometry_sdo_geom.sdo_length(2)

此状态信息仅写入到您的标准输出设备中，而不写入到日志文件中（如果存在一个有效的日志文件）。检查数据泵的活动已知缺陷概述下面概述了各个 Oracle10g 和 Orace11g 版本中已知的性能相关缺陷。请参阅概述之后的内容部分，以了解有关这些缺陷和可能的变通方案的详细信息。注意 1：除了数据泵特定的缺陷，其它组件例如与优化器相关的缺陷也会在数据泵作业期间对性能产生影响。下面仅列出了一些影响最大的缺陷。注意 2：使用指定的 NETWORK_LINK 参数执行导入时，影响 Export Data Pump 的缺陷也会对 Import Data Pump 产生影响。这些缺陷只在 Export Data Pump 部分列出一次。Export DataPump (expdp):10.1.0.1.0 至 10.1.0.3.0 Bug 3447032 Import Data Pump is slow when importing statistics Bug:4513695 Poor performance for SELECT with ROWNUM=1 with literal replacement Bug 5095025 Export Data Pump runs out of memory (ORA-4030) when exporting many schemas Bug:5464834 Export Data Pump runs out of memory (ORA-4030) when many tables are involved Bug:5590185 Consistent Export Data Pump is slow when exporting row data Bug:5928639 Export Data Pump of table can be very slow if CURSOR_SHARING is not EXACT Bug 5929373 Export Data Pump of a table can be very slow if database has many user tables 10.1.0.4.0 至 10.1.0.5.0 以及 10.2.0.1.0 至 10.2.0.3.0 Bug:4513695 Poor performance for SELECT with ROWNUM=1 with literal replacement Bug 5095025 Export Data Pump runs out of memory (ORA-4030) when exporting many schemas Bug:5464834 Export Data Pump runs out of memory (ORA-4030) when many tables are involved Bug:5590185 Consistent Export Data Pump is slow when exporting row data Bug:5928639 Export Data Pump of table can be very slow if CURSOR_SHARING is not EXACT Bug 5929373 Export Data Pump of a table can be very slow if database has many user tables Bug 5573425 Slow Datapump with wrong results due to subquery unnesting and complex view10.2.0.4.0 Bug 7413726 Poor EXPDP performance when db COMPATIBLE=10.2.0.3 or 10.2.0.4 (duplicate of Bug 7710931) Bug 7710931 DataPump export is extremely slow when extracting schema- Bug 6460304 (affects earlier versions as well) Expdp domain index dump using RULE Optimizer and slow Bug 7722575 -DATAPUMP VIEW KU$_NTABLE_DATA_VIEW causes poor plan / slow Expdp 11.1.0.6.0- Bug 7585314 OCSSD.BIN consumes much too much CPU while running Datapump Bug 7722575 DATAPUMP VIEW KU$_NTABLE_DATA_VIEW causes poor plan / slow Expdp11.1.0.7.0- Bug 8363441 Very Expensive Sql Statement During Datapump Import With Many Subpartitions- Bug 7722575 DATAPUMP VIEW KU$_NTABLE_DATA_VIEW causes poor plan / slow Expdp- Bug 8904037 LT_CTX_PKG.SCHEMA_INFO_EXP IS TAKING MORE TIME WHILE EXPORTING PROCO OECTS11.2.0.1- Bug 10178675 expdp slow with processing functional_and_bitmap/index- Bug 10194031 EXPDP OF OR XML LEAKS MEMORY / RUNS SLOW 11.2.0.1 WORKS 11.1.0.711.2.0.3- DATA PUMP PERFORMANCE FOR ESTIMATE=STATISTICS IN EXPORT IS BAD- Bug 13573203 SLOW INDEX EXPORT DUE TO PERFORMANCE ISSUE WITH METADATA KU$_INDEX_COL_VIEW- Bug 13914808 QUERY AGAINST KU$_INDEX_VIEW KU$ SLOW EVEN AFTER USING METADATA FROM 13844935Note:1)对于11.2.0.3, patch 16038089 中包含了以下修复:- Bug 12325243 SLOW PERFORMANCE ON EXPDP FUNCTIONAL AND BITMAP INDEXES- Unpublished Bug 12780993 DATA PUMP PERFORMANCE FOR ESTIMATE=STATISTICS IN EXPORT IS BAD- Bug 13573203 SLOW INDEX EXPORT DUE TO PERFORMANCE ISSUE WITH METADATA KU$_INDEX_COL_VIEW- Bug 13844935 QUERY AGAINST KU$_INDEX_VIEW SLOW IN 11.2.0.3- Bug 14192178 BUG 14006804 FIX DOES NOT RESOLVE THE PERFORMANCE ISSUE2)相对于Patch 16038089，下边两个patch是更好的选择：11.2.0.3 Patch 1589370011.2.0.3.3或更高 MLR Patch 14742362这是因为这两个patch包含了Patch 16038089中所有的修复，同时还修复了其它一些之前patch没有修复的性能问题。

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-48347-2.html