Database hang with 'log file sync' as top wait event while performing commit and rollback operations
After researched on the database hanging issue with ADDM, ASH, and AWR reports,I suspect the problem may be caused by the default log_buffer size is too large.
I queried the x$kcrfstrand and found all the 300 some private redo threads had been used
at high activity load time, can we balance this by adjusting the _log_io_size ?
I queried the x$kcrfstrand and found all the 300 some private redo threads had been used
at high activity load time, can we balance this by adjusting the _log_io_size ?
0