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

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:46

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

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】