oracle sqllder导入优化

原文地址
bindsize=134217728 rows=10000
direct=true
建表加nologging

调整了logfile的大小 原先每个50M 现在每个500M
关闭了系统表空间的自动扩展，手工指定，这个玩意扩展的时候效率很低
设置了参数sga_target=15g shared_pool_size=2g db_cache_size=10g pga_aggregate_target=5g

alter database datafile ‘/data/oradata/tydic/tbs_pms_data.dbf’ autoextend off;
show parameter sga_target;
show parameter shared_pool_size;
show parameter db_cache_size;
show parameter pga_aggregate_target;
show parameter sga_max_size;
ALTER SYSTEM SET sga_target = 15g SCOPE=BOTH;
ALTER SYSTEM SET sga_max_size=‘30g’ SCOPE=spfile;
ALTER SYSTEM SET SHARED_POOL_SIZE=‘2g’ SCOPE=BOTH;
ALTER SYSTEM SET db_cache_size=‘10g’ SCOPE=BOTH;
ALTER SYSTEM SET pga_aggregate_target=‘5g’ SCOPE=BOTH;

create spfile from pfile=’/opt/u01/app/init.ora’;
startup pfile=’/opt/u01/app/init.ora’;

alter database noarchivelog
alter table BLOG nologging