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