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

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-618246/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-618246/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值