我的数据库出现问题了,现象如下:
对表进行delete操作时,速度特别慢,
如表的数据量为1w左右(无索引,无外键),执行
delete ....0.4s;执行rollback或commit需要 15---30 s
insert的速度比较正常.
附件是oracle数据库的一些参数设置,大家帮我看看:
*.aq_tm_processes=0
*.compatible='9.2.0.7.0'
*.cursor_sharing='force'
*.db_block_size=16384
*.db_cache_size=8G
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_files=1300
*.db_writer_processes=8
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.java_pool_size=0
*.job_queue_processes=0
*.large_pool_size=0
*.log_archive_start=true
*.log_buffer=102400000
*.open_cursors=3000
*.pga_aggregate_target=2147483648
*.processes=3000
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=536870912
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=3600
|