Welcome 微信登录

首页 / 数据库 / MySQL / OSWatcher使用简介

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
 
CPU COUNT found on your system.
CPU COUNT = 2
 
Discovery completed.
#生成的archive目录下生成了对应不同收集信息的目录
[oracle@rhel6 oswbb]$ cd archive
[oracle@rhel6 archive]$ ls
oswifconfig  oswiostat  oswmeminfo  oswmpstat  oswnetstat  oswprvtnet  oswps  oswslabinfo  oswtop  oswvmstatMOS文档 ID 1531223.1有详细的介绍各个目录的含义。4、分析OSWatcher收集到的日志使用oswbba.jar包进行日志的分析,但是jara要在1.4.2及以上版本。两种方法分析数据1)生成图形[oracle@rhel6 oswbb]$ export DISPLAY=192.168.56.1:0.0
[oracle@rhel6 oswbb]$ java -jar oswbba.jar -i archive
 
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本文永久更新链接地址