Oracle OSWatcher Usage and OSWatcher Performance Reports ( OSWatcher logs for particular time )

I will explain Oracle OSWatcher Usage and its Performance Reports in this article.Let’s review the Oracle OSWatcher Performance Reports

 

 

Oracle OSWatcher Performance Reports

The OSWatcher tool is a very nice and useful tool written by Carl Davis, who collects and keeps statistical data of operating system resources periodically and reports to us. You can download and use OSWatcher software from metalink or Oracle support.

 

OSWatcher tool executes some commands such as TOP, iostat, vmstat, netstat at certain intervals and keep these data on Server. I strongly recommend that you use it in production environments. The installation and use of the tool is as follows.

 

 

 

OSWatcher Install

 

Step 1: Download OSWatcher  and extract it like following.

[oracle@MehmetSalih ~]$ls -l
-rw-r--r-- 1 oracle oinstall 6123520 Sep 05 11:27 oswbb730.tar


[oracle@MehmetSalih ~]$tar -xvf oswbb730.tar
x oswbb
x oswbb/data
x oswbb/docs
x oswbb/docs/The_Analyzer
x oswbb/docs/The_Analyzer/OSWatcherAnalyzerOverview.pdf, 393822 bytes, 770 media blocks.
x oswbb/docs/The_Analyzer/oswbbaUserGuide.pdf, 2095591 bytes, 4093 media blocks.
x oswbb/docs/The_Analyzer/oswbba_README.txt, 29099 bytes, 57 media blocks.
x oswbb/docs/OSWatcher
x oswbb/docs/OSWatcher/oswbb_README.txt, 13481 bytes, 27 media blocks.
x oswbb/docs/OSWatcher/OSWatcherUserGuide.pdf, 3195426 bytes, 6242 media blocks.
x oswbb/Exampleprivate.net, 1864 bytes, 4 media blocks.
x oswbb/nfssub.sh, 740 bytes, 2 media blocks.
x oswbb/stopOSWbb.sh, 558 bytes, 2 media blocks.
x oswbb/call_du.sh, 67 bytes, 1 media blocks.
x oswbb/iosub.sh, 743 bytes, 2 media blocks.
x oswbb/profile
x oswbb/OSWatcherFM.sh, 4424 bytes, 9 media blocks.
x oswbb/ifconfigsub.sh, 772 bytes, 2 media blocks.
x oswbb/ltop.sh, 1486 bytes, 3 media blocks.
x oswbb/mpsub.sh, 542 bytes, 2 media blocks.
x oswbb/call_uptime.sh, 71 bytes, 1 media blocks.
x oswbb/gif
x oswbb/psmemsub.sh, 1445 bytes, 3 media blocks.
x oswbb/tar_up_partial_archive.sh, 4219 bytes, 9 media blocks.
x oswbb/oswnet.sh, 435 bytes, 1 media blocks.
x oswbb/vmsub.sh, 544 bytes, 2 media blocks.
x oswbb/call_sar.sh, 68 bytes, 1 media blocks.
x oswbb/oswib.sh, 414 bytes, 1 media blocks.
x oswbb/startOSWbb.sh, 2385 bytes, 5 media blocks.
x oswbb/Example_extras.txt, 626 bytes, 2 media blocks.
x oswbb/oswsub.sh, 524 bytes, 2 media blocks.
x oswbb/analysis
x oswbb/oswbba.jar, 235115 bytes, 460 media blocks.
x oswbb/locks
x oswbb/tmp
x oswbb/OSWatcher.sh, 34522 bytes, 68 media blocks.
x oswbb/topaix.sh, 537 bytes, 2 media blocks.
x oswbb/tarupfiles.sh, 746 bytes, 2 media blocks.
x oswbb/xtop.sh, 1486 bytes, 3 media blocks.
x oswbb/src
x oswbb/src/Thumbs.db, 10240 bytes, 20 media blocks.
x oswbb/src/OSW_profile.htm, 26288 bytes, 52 media blocks.
x oswbb/src/tombody.gif, 4175 bytes, 9 media blocks.
x oswbb/src/missing_graphic.gif, 8694 bytes, 17 media blocks.
x oswbb/src/coe_logo.gif, 2994 bytes, 6 media blocks.
x oswbb/src/watch.gif, 5621 bytes, 11 media blocks.
x oswbb/src/oswbba_input.txt, 135 bytes, 1 media blocks.
x oswbb/oswrds.sh, 825 bytes, 2 media blocks.
[oracle@MehmetSalih ~]$

 

 

Step 2: Contents of OSWatcher are like following.

[oracle@MehmetSalih ~]$ls -all
drwxr-xr-x 10 oracle oinstall 4096 May 28 19:44 oswbb
-rw-r--r-- 1 oracle oinstall 6123520 Sep 05 11:27 oswbb730.tar

[oracle@MehmetSalih ~]$cd oswbb

[oracle@MehmetSalih ~]ls -all
total 752
drwxr-xr-x 10 oracle oinstall 4096 May 28 19:44 .
drwxr-xr-x 3 oracle oinstall 256 Sep 05 14:12 ..
-rwxr-xr-x 1 oracle oinstall 626 Jan 15 2018 Example_extras.txt
-rwxr-xr-x 1 oracle oinstall 1864 Oct 07 2017 Exampleprivate.net
-rwxr-xr-x 1 oracle oinstall 34522 May 28 19:10 OSWatcher.sh
-rwxr-xr-x 1 oracle oinstall 4424 Oct 16 2017 OSWatcherFM.sh
drwxr-xr-x 2 oracle oinstall 256 May 02 13:46 analysis
-rwxr-xr-x 1 oracle oinstall 67 Jan 15 2018 call_du.sh
-rwxr-xr-x 1 oracle oinstall 68 Oct 07 2017 call_sar.sh
-rwxr-xr-x 1 oracle oinstall 71 Jan 07 2018 call_uptime.sh
drwxr-xr-x 2 oracle oinstall 256 May 02 13:46 data
drwxr-xr-x 4 oracle oinstall 256 May 02 13:48 docs
drwxr-xr-x 2 oracle oinstall 256 May 02 13:49 gif
-rwxr-xr-x 1 oracle oinstall 772 May 08 16:21 ifconfigsub.sh
-rwxr-xr-x 1 oracle oinstall 743 Oct 07 2017 iosub.sh
drwxr-xr-x 2 oracle oinstall 256 May 28 19:43 locks
-rwxr-xr-x 1 oracle oinstall 1486 Jan 08 2018 ltop.sh
-rwxr-xr-x 1 oracle oinstall 542 Oct 07 2017 mpsub.sh
-rwxr-xr-x 1 oracle oinstall 740 Oct 07 2017 nfssub.sh
-rw-r--r-- 1 oracle oinstall 235115 May 21 18:54 oswbba.jar
-rwxr-xr-x 1 oracle oinstall 414 Oct 07 2017 oswib.sh
-rwxr-xr-x 1 oracle oinstall 435 Jan 08 2018 oswnet.sh
-rwxr-xr-x 1 oracle oinstall 825 Oct 07 2017 oswrds.sh
-rwxr-xr-x 1 oracle oinstall 524 Oct 07 2017 oswsub.sh
drwxr-xr-x 2 oracle oinstall 256 May 02 13:50 profile
-rwxr-xr-x 1 oracle oinstall 1445 Oct 18 2017 psmemsub.sh
drwxr-xr-x 2 oracle oinstall 256 May 02 13:50 src
-rwxr-xr-x 1 oracle oinstall 2385 Oct 07 2017 startOSWbb.sh
-rwxr-xr-x 1 oracle oinstall 558 Apr 17 15:34 stopOSWbb.sh
-rwxr-xr-x 1 oracle oinstall 4219 Nov 06 2017 tar_up_partial_archive.sh
-rwxr-xr-x 1 oracle oinstall 746 Nov 06 2017 tarupfiles.sh
drwxr-xr-x 2 oracle oinstall 256 May 28 19:43 tmp
-rwxr-xr-x 1 oracle oinstall 537 Jan 08 2018 topaix.sh
-rwxr-xr-x 1 oracle oinstall 544 Oct 07 2017 vmsub.sh
-rwxr-xr-x 1 oracle oinstall 1486 Jan 08 2018 xtop.sh

 

Step 3:   To start OSWatcher tool, execute startOSWbb.sh like following.

startOSW.sh <SnapshotInterval > <ArchiveInterval>

 

For examle; If we start OSWatcger like sh startOSWbb.sh 30 720,  then OSWatcher is triggered and run every 30 second and keeps these data 720 hours, 30 days.

 

 

 

Start it like following.

 [oracle@MehmetSalih ~]$ sh startOSWbb.sh
 [oracle@MehmetSalih ~]$ 
 Info...You did not enter a value for snapshotInterval.
 Info...Using default value = 30
 Info...You did not enter a value for archiveInterval.
 Info...Using default value = 48
 Setting the archive log directory to/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.
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.
Starting OSWatcher Black Box v7.3.0 on Fri Sep 5 14:13:02 EEST 2018
 With SnapshotInterval = 30
 With ArchiveInterval = 48
OSWatcher Black Box - Written by Carl Davis, Center of Expertise,
 Oracle Corporation
 For questions on install/usage please go to MOS (Note:301137.1)
 If you need further assistance or have comments or enhancement
 requests you can email me [email protected]
Data is stored in directory: /oracle/oswatcher/oswbb/archive
Starting Data Collection...
 oswbb heartbeat:Fri Sep 5 14:13:07 EEST 2018
 oswbb heartbeat:Fri Sep 5 14:13:37 EEST 2018
 oswbb heartbeat:Fri Sep 5 14:14:07 EEST 2018
 oswbb heartbeat:Fri Sep 5 14:14:37 EEST 2018
 oswbb heartbeat:Fri Sep 5 14:15:08 EEST 2018

Step 4:  you can stop OSWatcher like following.

 [oracle@MehmetSalih ~]$ sh stopOSWbb.sh

 

 

6.Adım: You can report OSWatcher data using black box analyzer tool like following.

[oracle@MehmetSalih ~]$ java -jar oswbba.jar -i archive
Starting OSW Analyzer V7.3.0
 OSWatcher Analyzer Written by Oracle Center of Expertise
 Copyright (c) 2018 by Oracle Corporation
Parsing Data. Please Wait...
This directory already exists. Rewriting...
 Scanning file headers for version and platform info...
 Parsing file archive/oswiostat/testsunucu_iostat_14.09.05.1400.dat ...
 Parsing file testsunucu_vmstat_14.09.05.1400.dat ...
Parsing file testsunucu_netstat_14.09.05.1400.dat ...
 Parsing file testsunucu_top_14.09.05.1400.dat ...
Parsing file testsunucu_ps_14.09.05.1400.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:2
 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:
[oracle@MehmetSalih ~]$

OSWatcher Performance Reports

These reports generated from OSWatches are like following.

 

CPU Report

 

Memory Report

 

 

 

Do you want to learn Oracle Database Performance Tuning detailed, then Click this link.