Oracle工具:OS Watcher

OS Watcher是用收集并归档操作系统和网络开销的一套shell脚本，当数据库出现故障时可以帮助DBA问题分析诊断问题。OSW是一组后台进程，用于获取规则的操作系统数据，它调用的是Unix的vmstat,netstat和iostat.

 

[root@LGXRH1 kernel]# mount.cifs //192.168.64.1/temp /mnt/share -o user=adminstrator
Password:
[root@LGXRH1 kernel]# cd /mnt/share
log2.log                             osw212.tar
[root@LGXRH1 share]# cp osw212.tar ~/
[root@LGXRH1 ~]# tar xvf osw212.tar
[root@LGXRH1 osw]# ./startOSW.sh 5 1  

 

5秒钟收集一次信息，持续1小时

 

将收集的信息通过图形化界面显示出来，更加直观地

[oracle@LGXRH1 ~]$ export DISPLAY=192.168.64.1:0.0  #在操作的机器x程序显示都送到当时操作虚拟机的IP
[oracle@LGXRH1 ~]$ dbca
[oracle@LGXRH1 ~]$  export PATH=$ORACLE_HOME/jre/1.4.2/bin:$PATH
[oracle@LGXRH1 ~]$ cd /root/osw
[oracle@LGXRH1 osw]$ ls
archive             OSWatcherFM.sh  OSWgREADME    oswnet.sh    profile  startOSW.sh    tmp
Exampleprivate.net  OSWatcher.sh    oswlnxio.sh   oswsub.sh    README   stopOSW.sh     topaix.sh
gif                 oswg.jar        oswlnxtop.sh  private.net  src      tarupfiles.sh
[oracle@LGXRH1 osw]$ java -jar oswg.jar -i ./archive
 
Starting OSWg V2.1.2
OSWatcher Graph Written by Oracle Center of Expertise
Copyright (c)  2008 by Oracle Corporation
 
Parsing Data. Please Wait...
 
Parsing file LGXRH1_iostat_09.05.26.2300.dat ...
Parsing file LGXRH1_iostat_09.05.27.0000.dat ...
Parsing file LGXRH1_iostat_09.06.18.1200.dat ...
 
Parsing file LGXRH1_vmstat_09.05.26.2300.dat ...
Parsing file LGXRH1_vmstat_09.05.27.0000.dat ...
Parsing file LGXRH1_vmstat_09.06.18.1200.dat ...
Invalid data found on line 6
Invalid data found on line 228
Invalid data found on line 342
 
Parsing Completed.
 
 
 
 
 
Enter 1 to Display CPU Process Queue Graphs
Enter 2 to Display CPU Utilization Graphs
Enter 3 to Display CPU Other Graphs
Enter 4 to Display Memory Graphs
 
Enter 6 to Generate All CPU Gif Files
Enter 7 to Generate All Memory Gif Files
 
Enter L to Specify Alternate Location of Gif Directory
Enter T to Specify Different Time Scale
Enter D to Return to Default Time Scale
Enter R to Remove Currently Displayed Graphs
Enter P to Generate A Profile
Enter Q to Quit Program
 
Please Select an Option:1
 
 
 
 
Enter 1 to Display CPU Process Queue Graphs
Enter 2 to Display CPU Utilization Graphs
Enter 3 to Display CPU Other Graphs
Enter 4 to Display Memory Graphs
 
Enter 6 to Generate All CPU Gif Files
Enter 7 to Generate All Memory Gif Files
 
Enter L to Specify Alternate Location of Gif Directory
Enter T to Specify Different Time Scale
Enter D to Return to Default Time Scale
Enter R to Remove Currently Displayed Graphs
Enter P to Generate A Profile
Enter Q to Quit Program
 
Please Select an Option:q
[oracle@LGXRH1 osw]$