oracle 10g asm数据库imp导入慢处理

环境:oracle 10GR2 +aIx+6.1+asm+emc存储

数据库参数已经调整,imp buffer参数也已经加大,唯一没修改的就是asm实例参数保持默认
设置,没做任何修改,开始做imp时,速度非常慢,一个小时才导入5G

通过检查和查询相关文档,asm实例参数做了以下调整:
.shared_pool_size = 12M
.large_pool = 128M
.db_cache_size = 64M
.processes=100

然后重新导入正常,一个小时达到了30多G,是可以接受的速度。

上面这几个asm参数值是oracle建议设置的，下面large_pool参考设置值
Large_pool – Additional memory is required to store extent maps. Aggregate the values from the
following queries to obtain current database storage size that is either already on ASM or will be stored in
ASM. Then determine the redundancy type that is used (or will be used), and calculate the shared_pool,
using the aggregated value as input.
select sum(bytes)/(1024*1024*1024) from v$datafile;
select sum(bytes)/(1024*1024*1024) from v$logfile a, v$log b
where a.group#=b.group#;
select sum(bytes)/(1024*1024*1024) from v$tempfile where
status='ONLINE';
For diskgroups using external redundancy = (Every 100Gb of space needs
1Mb of extra shared pool) + 2M
For diskgroups using Normal redundancy: (Every 50Gb of space needs 1Mb of
extra shared pool) + 4M.
For diskgroups using High redundancy: (Every 33Gb of space needs 1Mb of
extra shared pool) + 6M