Whenever DB console runs on Linux, lot of processes in "D" state with wchan sync_buffer or sync_page
I have an 11203 RAC database and clusterware running on OEL 5.
One node is fine, the other node consistently crawls to a halt with these symptoms:
* top shows CPU 90%+ wait (!)
* ps shows a lot of processes in "D" state waiting on "sync_buffer" and "sync_page"
* this only seems to happen when I get EM DB Console up and running - and the db console doesn't run on the OK node.
(Note : not using Grid Control, just DB Console - emctl start dbconsole, started from database home)
I thought swapping could be part of the problem - the system has only 2GB memory - but I reduced memory_target by 150M and saw no improvement.
One node is fine, the other node consistently crawls to a halt with these symptoms:
* top shows CPU 90%+ wait (!)
* ps shows a lot of processes in "D" state waiting on "sync_buffer" and "sync_page"
* this only seems to happen when I get EM DB Console up and running - and the db console doesn't run on the OK node.
(Note : not using Grid Control, just DB Console - emctl start dbconsole, started from database home)
I thought swapping could be part of the problem - the system has only 2GB memory - but I reduced memory_target by 150M and saw no improvement.
0