oracle 插入大量数据时,可用交换分区减少!急等!!
oracle 插入大量数据时,可用交换分区减少。
OS:tru64 Cluster
oralce: oracle9.2.0.1 RAC
集群使用网卡连接。
当insert 大量数据时,可用交换分区减少。
init.ora 如下:
*.aq_tm_processes=1
*.background_dump_dest='/u01/app/oracle/admin/abc/bdump'
*.cluster_database_instances=2
*.cluster_database=true
*.compatible='9.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/abc/control01.ctl','/u01/app/oracle/oradata/abc/control02.ctl','/u01/app/oracle/oradata/abc/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/abc/cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='abc'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
abc1.instance_name='abc1'
abc2.instance_name='abc2'
abc2.instance_number=2
abc1.instance_number=1
*.java_pool_size=0
*.job_queue_processes=10
*.large_pool_size=8388608
*.local_listener='LISTENER_abc'
abc1.local_listener='LISTENER_abc1'
abc2.local_listener='LISTENER_abc2'
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_listener='LISTENERS_ABC'
*.remote_login_passwordfile='exclusive'
*.shared_pool_size=104857600
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
abc1.thread=1
abc2.thread=2
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=60
abc1.undo_tablespace='UNDOTBS1'
abc2.undo_tablespace='UNDOTBS2'
*.user_dump_dest='/u01/app/oracle/admin/abc/udump'