dblink sdo_geometry_Oracle sdo_geometry_sdo_geom.sdo_length(3)

3)所有8个 bug 都在Patch 14742362中修复并已包含11.2.0.4补丁集中，详见：Note 1562142.1 11.2.0.4 Patch Set List of Bug Fixes by Problem Type Import DataPump (impdp):10.1.0.1.0 至 10.1.0.3.0 Bug 3447032 Import Data Pump is slow when importing statistics Bug:5292551 Import Data Pump runs out of memory (ORA-04030) and can be very slow on certain tables Bug 5555463 Import Data Pump can be slow when importing small LOBs in External Table mode10.1.0.4.0 Bug:5292551 Import Data Pump runs out of memory (ORA-04030) and can be very slow on certain tables Bug 5555463 Import Data Pump can be slow when importing small LOBs in External Table mode 10.1.0.5.0 Bug 3508675 Import Data Pump is slow when importing TABLE_DATA Bug:5292551 Import Data Pump runs out of memory (ORA-04030) and can be very slow on certain tables Bug 5555463 Import Data Pump can be slow when importing small LOBs in External Table mode 10.2.0.1.0 至 10.2.0.3.0 Bug:5071931 Import Data Pump with REMAP_SCHEMA and REMAP_TABLESPACE is slow Bug:5292551 Import Data Pump runs out of memory (ORA-04030) and can be very slow on certain tables Bug 6989875 -Transportable Tablespace Import Spins Using CPU Bug 5555463 Import Data Pump can be slow when importing small LOBs in External Table mode10.2.0.4.0 Bug 7439689 (affects earlier versions as well) Impdp workeer process spinning on MERGE statement11.1.0.6.0 Bug 7585314 OCSSD.BIN consumes much too much CPU while running Datapump11.1.0.7.0- Bug 8363441 Very Expensive Sql Statement During Datapump Import With Many Subpartitions 缺陷详细信息Bug 3447032 Import Data Pump is slow when importing statistics- 缺陷：Bug 3447032“DBMS_STATS.SET_COLUMN_STATS can be slow (affects IMPORT)”（不是公开的 bug）- 症状：导入 INDEX_STATISTICS 或 TABLE_STATISTICS 时，Import（传统客户端）或 Import Data Pump 作业可能显示很长的等待时间 版本：10.1.0.3.0 及更低版本- 已在以下版本中修正：10.1.0.4.0 及更高版本；对于某些平台, Patch:3447032 提供了针对 10.1.0.3.0 的修正- 打过补丁的文件：exuazo.o kustat.xsl- 变通方案：排除统计信息导入 (EXCLUDE=statistics)，并在导入完成后手动创建统计信息 原因：如何在带有（许多）子分区的表中设置列统计信息的问题 跟踪：SQL 跟踪显示对 DBMS_STATS 包的引用 备注：必须在两个站点（源和目标）上都应用此 bug 的修正，且必须重新生成全部的 Export 或 Export Data Pump 转储文件，以便在导入时获取性能提升。

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