Dynamic Instance Resizing and log buffer

1.

v$buffer_pool

 

2.查看redo_buffer是否存在问题

   查看lgwn是否存在等待时间

  1.select sid,event,seconds_in_wait,state from v$session_wait

where event='log buffer space';

 

   2.查看是否等待archive 进程

  select  * from v$sgastat where name = 'redo entries' or name = 'redo buffer allocation retries';

两个value值的比例越小越好