OSWatcher Black Box, ??OSW,?oracle???????????????,?????OS??????????OS??????????,??CPU/Memory/Swap/Network IO/Disk IO??????
+++ ????????OSW?
OSW?????????,????????????????,???mrtg, cacti, sar, nmon, enterprise manger grid control.
????OSW?????:
1. ???????,???????2. ???????,????CPU,???????????3. ???????,????????????????????????OS?
???????OS???,??OS?????,?????????????;??????????????????????,???????.
???????,????????:?????????,??????????,????????????(root cause),?????????????????????????,OSW??????,??????:
1. ??????????OS??????????????????????????OSW??,?????????OS??,??????DB/????
2. ??ORACLE Database Performance???,?????????????OS??????OS?????????????Swapping,???????????????,?????????,???AWR?????????latch/mutex??????
3. ??????????????AWR??????????,top5??????????;?CPU,??,Swap, Disk IO?????????????OSW??????????,????????????????????????OSW???,???????????????
4. ?????ORA-04030?????CJQ0, P00X, J00X?????????,???????OSW,???????????????????OS?????????
5. ????server process??hung?,??????OSW????????????????suspend???,?????????CPU/Memory?
6. ??Listener hung???,?????OSW???????????????
7. Login Storm??:????????????,????,????ASH,AWR????????????????OSW?ps?????,??????, oracle ?server process?????????
???,OSW????????????????????OS?????????????,??????DBA???OSW??????????????OSW,????DB Performance????,????????OSW????
+++ ?????OSW??????:
1. ??????????????,???????,????????
2. OSW????????
OSW??????????????OS???????,??ps, vmstat, netstat, mpstat, top;????????????????? ?????????CPU, Disk IO, Disk Space, Memory;???????????????,??????????????????????????,??OSW????????:?????????,CPU????90%??;???free space???????????????????????????,??OSW?????????
+++ ????????UNIX/LINUX???/??OSW:
1. ???301137.1???OSW
2. ????????(/tmp??),??????????root??
$ tar xvf osw.tar
3. ??
$ nohup ./startOSWbb.sh 60 48 gzip &
????????,??OSW,????60???????,???????48?????(??????????),???????gzip??????
4. ?????
$ ./stopOSWbb.sh
?????????archive????
????????????????????OSW???????,???????