(5)对于log file parallel write等待事件,和上面一样建议将重做日志放到较快的磁盘上进行存储。
故障处理
调整initorcl.ora里不合理的参数,具体调整为:
process=200
log_buffer=1048576
session_cached_cursors=200
db_block_lru_latches=2
shared_pool_size= 262144000
db_block_buffers = 200000
sort_area_size = 6553600
sort_area_retained_size = 6553600
db_file_multiblock_read_count = 16