OSWatcher Black Box, 简称OSW,是Oracle提供的一个小但是非常有用的工具,它通过调用OS自己提供的命令来记录OS运行时的一些性能参数,比如CPU/Memory/Swap/Network IO/Disk IO相关的信息。但是部署OSW有很多好处:1. 它比较容易部署,并且容易删除。 2. 资源消耗比较小,不管是从CPU,内存还是磁盘空间来说。 3. 平时不需要维护,并且在发生问题时可以帮我们迅速定位问题是否发生在OS端数据库是运行在OS之上的,如果OS发生了异常,那么数据库肯定也会受到影响;如果我们仅仅从数据库的角度去分析这样的问题时,很难有个好结果.官方博客介绍点击这里。1、下载从MOS上里的文档301137.1上下载OSW,需要有MOS账号或者到Linux公社1号FTP服务器下载------------------------------------------分割线------------------------------------------FTP地址:ftp://ftp1.linuxidc.com用户名:ftp1.linuxidc.com密码:www.linuxidc.com在 2016年LinuxIDC.com12月OSWatcher使用简介下载方法见 http://www.linuxidc.com/Linux/2013-10/91140.htm------------------------------------------分割线------------------------------------------ 2、安装随便找一个目录解压安装,不要在/tmp目录,不必须root用户[oracle@rhel6 ~]$ mkdir oswatcher [oracle@rhel6 ~]$ mv oswbb734.tar oswatcher/ [oracle@rhel6 ~]$ cd oswatcher/ [oracle@rhel6 oswatcher]$ ls oswbb734.tar [oracle@rhel6 oswatcher]$ tar -xvf oswbb734.tar oswbb/ oswbb/call_uptime.sh oswbb/profile/ oswbb/analysis/ oswbb/tar_up_partial_archive.sh oswbb/oswsub.sh oswbb/oswrds.sh oswbb/src/ oswbb/src/missing_graphic.gif oswbb/src/tombody.gif oswbb/src/coe_logo.gif oswbb/src/Thumbs.db oswbb/src/OSW_profile.htm oswbb/src/oswbba_input.txt oswbb/src/watch.gif oswbb/oswib.sh oswbb/call_du.sh oswbb/tarupfiles.sh oswbb/ltop.sh oswbb/nfssub.sh oswbb/docs/ oswbb/docs/OSWatcher/ oswbb/docs/OSWatcher/OSWatcherUserGuide.pdf oswbb/docs/OSWatcher/oswbb_README.txt oswbb/docs/The_Analyzer/ oswbb/docs/The_Analyzer/oswbba_README.txt oswbb/docs/The_Analyzer/oswbbaUserGuide.pdf oswbb/docs/The_Analyzer/OSWatcherAnalyzerOverview.pdf oswbb/OSWatcher.sh oswbb/psmemsub.sh oswbb/call_sar.sh oswbb/oswnet.sh oswbb/Exampleprivate.net oswbb/mpsub.sh oswbb/Example_extras.txt oswbb/OSWatcherFM.sh oswbb/startOSWbb.sh oswbb/ifconfigsub.sh oswbb/iosub.sh oswbb/oswbba.jar oswbb/vmsub.sh oswbb/xtop.sh oswbb/stopOSWbb.shOSWatcher包含两部分:oswbb:这是一个shell脚本,用于收集和存储数据oswbba:这是一个java工具用于分析收集到的数据并提供建议,还可以生成图片或html文档。3、启动OSWatcherstartOSWbb.sh脚本有四个参数:ARG1 = snapshot interval in seconds. ARG2 = the number of hours of archive data to store. ARG3 = (optional) the name of a compress utility to compress each file automatically after it is created. ARG4 = (optional) an alternate (non default) location to store the archive directory.如果不输入任何参数,默认间隔30秒收集一次数据,并且默认保存48小时的数据。默认收集到的数据会存储在解压目录下的archive目录下,这个目录是在第一次启动startOSWbb.sh脚本时创建的。#启动startOSWbb.sh脚本,间隔15秒,保存5天的数据 [oracle@rhel6 oswbb]$ nohup sh startOSWbb.sh 15 120 & [1] 3131 [oracle@rhel6 oswbb]$ nohup: ignoring input and appending output to `nohup.out"
[1]+ Done nohup sh startOSWbb.sh 15 120 #查看输出日志 [oracle@rhel6 oswbb]$ more nohup.out Setting the archive log directory to/home/oracle/oswatcher/oswbb/archive
Testing for discovery of OS Utilities... VMSTAT found on your system. IOSTAT found on your system. MPSTAT found on your system. IFCONFIG found on your system. NETSTAT found on your system. TOP found on your system.
Testing for discovery of OS CPU COUNT oswbb is looking for the CPU COUNT on your system CPU COUNT will be used by oswbba to automatically look for cpu problems
Starting OSW Analyzer V7.3.3 OSWatcher Analyzer Written by Oracle Center of Expertise Copyright (c) 2014 by Oracle Corporation
Parsing Data. Please Wait...
Scanning file headers for version and platform info...
Parsing file rhel6_iostat_16.12.19.1100.dat ...
Parsing file rhel6_vmstat_16.12.19.1100.dat ...
Parsing file rhel6_netstat_16.12.19.1100.dat ...
Parsing file rhel6_top_16.12.19.1100.dat ...
Parsing file rhel6_ps_16.12.19.1100.dat ...
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 5 to Display Disk IO Graphs
Enter 6 to Generate All CPU Gif Files Enter 7 to Generate All Memory Gif Files Enter 8 to Generate All Disk Gif Files
Enter L to Specify Alternate Location of Gif Directory Enter T to Alter Graph Time Scale Only (Does not change analysis dataset) Enter D to Return to Default Graph Time Scale Enter R to Remove Currently Displayed Graphs
Enter A to Analyze Data Enter S to Analyze Subset of Data(Changes analysis dataset including graph time scale)
Enter P to Generate A Profile Enter X to Export Parsed Data to File Enter Q to Quit Program
Please Select an Option:7 Generating file gif/Dec19110157_1482117313/OSWg_OS_Memory_Swap.gif Generating file gif/Dec19110157_1482117313/OSWg_OS_Memory_Free.gif Generating file gif/Dec19110157_1482117313/OSWg_OS_Memory_Page_In_Rate.gif2)生成报告[oracle@rhel6 oswbb]$ java -jar oswbba.jar -i archive -A Scanning file headers for version and platform info...
Parsing file rhel6_iostat_16.12.19.1100.dat ...
Parsing file rhel6_vmstat_16.12.19.1100.dat ...
Parsing file rhel6_netstat_16.12.19.1100.dat ...
Parsing file rhel6_top_16.12.19.1100.dat ...
Parsing file rhel6_ps_16.12.19.1100.dat ...
Dates accepted. Verifying valid begin/end data points...
Validating times in the archive...
Recalibrating data... Scanning file headers for version and platform info...
Parsing file rhel6_iostat_16.12.19.1100.dat ...
Parsing file rhel6_vmstat_16.12.19.1100.dat ...
Parsing file rhel6_netstat_16.12.19.1100.dat ...
Parsing file rhel6_top_16.12.19.1100.dat ...
Parsing file rhel6_ps_16.12.19.1100.dat ...
A new analysis file analysis/rhel6_1482117679897.txt has been created. #生成的分析报告在analysis目录中 [oracle@rhel6 oswbb]$ more analysis/rhel6_1482117679897.txt This report is best viewed in a fixed font editor like textpad...
OSWatcher Analyzer
Input Archive: archive Archive Source Dest: /home/oracle/oswatcher/oswbb/archive Archive Start Time: Dec 19 11:01:57 2016 Archive Stop Time: Dec 19 11:20:59 2016 Hostname: RHEL6 OS Version: Linux Snapshot Freq: 15 CPU COUNT: 2 ...... Subsystem Status ------------------------ CPU OK MEMORY OK I/O WARNING NET OK ......MOS文档 ID 461053.1有详细介绍使用分析工具。更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12本文永久更新链接地址