情况:
1.我有两个数据库db1, db2,我建了一个db link, 想把 db1的 t1中
导入到db2的t2中, 主要采用的两种方法
t1 和 t2 都是分区表, 按照每个月的日分区,大概30区,每个分区
大概100多万数据,因为t1,t2的结构不一致,不方便用 imp/exp
1)准备通过db link, 但是发觉db2不能识别 db link的分区表,
partition 不起作用
2) 采用 copy的方法, 但是发觉copy的方法特慢,希望大家帮忙找找原因
主要是db2的速度特慢
3) 补充,db1和db2的软硬硬件环境类似,
1. 环境
db2
bash-2.03$ uname -a
SunOS hn-dwsvr 5.8 Generic_117350-43 sun4u sparc SUNW,Sun-Fire-V440
bash-2.03$ /usr/sbin/prtconf| grep 'Memory size'
Memory size: 16384 Megabytes
bash-2.03$ /usr/sbin/swap -s
total: 4880512k bytes allocated + 306328k reserved = 5186840k used, 41108736k available
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
PL/SQL Release 8.1.7.4.0 - Production
CORE8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
SQL> show sga
Total System Global Area 4653862588 bytes
Fixed Size
102076 bytes
Variable Size
1429372928 bytes
Database Buffers 3221225472 bytes
Redo Buffers
3162112 bytes
SQL> select * from v$log;
GROUP#THREAD#SEQUENCE#BYTESMEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1
1595209715200
1 NOACTIVE
8.9885E+12 04-SEP-07
2
1598209715200
1 NOCURRENT
8.9885E+12 04-SEP-07
3
1596209715200
1 NOACTIVE
8.9885E+12 04-SEP-07
4
1597209715200
1 NOACTIVE
8.9885E+12 04-SEP-07
2. 做了一个 statspack,见附件
3。随便贴一点告警日志
Tue Sep4 15:15:09 2007
Completed checkpoint up to RBA [0x252.2.10], SCN: 0x082c.ca1e2638
Tue Sep4 15:15:09 2007
Beginning log switch checkpoint up to RBA [0x255.2.10], SCN: 0x082c.ca1e5bb4
Thread 1 advanced to log sequence 597
Current log# 4 seq# 597 mem# 0: /oracle_hndw_2_s/oradata/redo0401.log
Tue Sep4 15:15:09 2007
ARC0: media recovery disabled
Tue Sep4 15:20:40 2007
Thread 1 cannot allocate new log, sequence 598
Checkpoint not complete
Current log# 4 seq# 597 mem# 0: /oracle_hndw_2_s/oradata/redo0401.log
Tue Sep4 15:26:06 2007
Completed checkpoint up to RBA [0x253.2.10], SCN: 0x082c.ca1e3bfa
Tue Sep4 15:26:06 2007
Beginning log switch checkpoint up to RBA [0x256.2.10], SCN: 0x082c.ca1e68b8
Thread 1 advanced to log sequence 598
Current log# 2 seq# 598 mem# 0: /oracle_hndw_2_s/oradata/redo0201.log
Tue Sep4 15:26:06 2007
ARC0: media recovery disabled
Tue Sep4 15:32:35 2007
Thread 1 cannot allocate new log, sequence 599
Checkpoint not complete
Current log# 2 seq# 598 mem# 0: /oracle_hndw_2_s/oradata/redo0201.log
Tue Sep4 15:37:37 2007
Completed checkpoint up to RBA [0x254.2.10], SCN: 0x082c.ca1e4fc1
Tue Sep4 15:37:38 2007
Beginning log switch checkpoint up to RBA [0x257.2.10], SCN: 0x082c.ca1e79ef
Thread 1 advanced to log sequence 599
Current log# 1 seq# 599 mem# 0: /oracle_hndw_2_s/oradata/redo0101.log
Tue Sep4 15:37:38 2007
ARC0: media recovery disabled
|