OSWATCHER INSTALL

Download OSWATCHER file from the below link

https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=301137.1:OSW_file.

Copy the file to the server using winscp and untar the OSWBB file

[oracle@orcl19x oswbb]$ tar -xvf oswbb840.tar

Go to the oswbb directory

[oracle@orcl19x oswbb]$ cd oswbb/
[oracle@orcl19x oswbb]$ ls
analysis        docs                locks           oswib.sh     sarsub.sh
archive         Example_extras.txt  ltop.sh         oswnet.sh    src
arpsub.sh       Exampleprivate.net  mpsub.sh        oswrds.sh    startOSWbb.sh
call_du.sh      genprvnet.sh        nfssub.sh       oswsub.sh    stopOSWbb.sh
call_sar.sh     gif                 OSWatcherFM.sh  piddsub.sh   tar_up_full_arc
call_uptime.sh  ifconfigsub.sh      OSWatcher.sh    pidsub.sh    tar_up_partial_
data            iosub.sh            oswbba.jar      psmemsub.sh  tmp

Check if ksh package is installed on your system

[oracle@orcl19x oswbb]$ rpm -qa|grep ksh
ksh-20120801-142.0.1.el7.x86_64

[oracle@orcl19x oswbb]$ ln -s /bin/ksh /usr/bin/ksh
ln: failed to create symbolic link ‘/usr/bin/ksh’: File exists

[oracle@orcl19x oswbb]$ ls -lrt /usr/bin/ksh
lrwxrwxrwx. 1 root root 21 Dec 13 11:21 /usr/bin/ksh -> /etc/alternatives/ksh

Sample output from oswatcher script with snapshot interval of 5 and archive data collection for 10 hours

[oracle@orcl19x oswbb]$ ./OSWatcher.sh 5 10
Setting the archive log directory to/home/oracle/oswbb/oswbb/archive

Testing for discovery of OS Utilities...
VMSTAT found on your system.
IOSTAT found on your system.
MPSTAT found on your system.
IP found on your system.
TOP found on your system.
Warning... /proc/slabinfo not found on your system. Check to see if this user ha                         s permission to access this file.
PIDSTAT found on your system.
NFSIOSTAT found on your system.
TRACEROUTE found on your system.

Discovery of CPU CORE COUNT
CPU CORE COUNT will be used by oswbba to automatically look for cpu problems

CPU CORE COUNT = 1
VCPUS/THREADS = 1

Discovery completed.

Starting OSWatcher v8.4.0  on Sat May 29 22:15:40 IST 2021
With SnapshotInterval = 5
With ArchiveInterval = 10

OSWatcher - Written by Carl Davis, Center of Expertise,
Oracle Corporation
For questions on install/usage please go to MOS (Note:301137.1)

Data is stored in directory: /home/oracle/oswbb/oswbb/archive

Starting Data Collection...

oswbb heartbeat:Sat May 29 22:15:45 IST 2021
oswbb heartbeat:Sat May 29 22:15:51 IST 2021
oswbb heartbeat:Sat May 29 22:15:56 IST 2021
oswbb heartbeat:Sat May 29 22:16:01 IST 2021
oswbb heartbeat:Sat May 29 22:16:06 IST 2021
oswbb heartbeat:Sat May 29 22:16:12 IST 2021
oswbb heartbeat:Sat May 29 22:16:17 IST 2021
oswbb heartbeat:Sat May 29 22:16:22 IST 2021
oswbb heartbeat:Sat May 29 22:16:27 IST 2021
oswbb heartbeat:Sat May 29 22:16:32 IST 2021
oswbb heartbeat:Sat May 29 22:16:38 IST 2021
oswbb heartbeat:Sat May 29 22:16:43 IST 2021
oswbb heartbeat:Sat May 29 22:16:48 IST 2021
oswbb heartbeat:Sat May 29 22:16:53 IST 2021
oswbb heartbeat:Sat May 29 22:16:59 IST 2021
***Warning. VMSTAT response is spanning snapshot intervals.
***Warning. MPSTAT response is spanning snapshot intervals.
***Warning. IOSTAT response is spanning snapshot intervals.
***Warning. PIDSTAT -d response is spanning snapshot intervals.
***Warning. PIDSTAT response is spanning snapshot intervals.
***Warning. TOP response is spanning snapshot intervals.

To run the script in background, use nohup mode

[oracle@orcl19x oswbb]$ nohup ./OSWatcher.sh 30 10 &
[1] 7682
[oracle@orcl19x oswbb]$ nohup: ignoring input and appending output to ‘nohup.out’

There are lot of reports generated by this script and choose the one for which you need to analyze

[oracle@orcl19x archive]$ java -jar /home/oracle/oswbb/oswbb/oswbba.jar -I /home/oracle/oswbb/oswbb/archive -B May 29 22:15:14 2021 -E May 29 22:16:14 2021

Validating times in the archive...


Starting OSW Analyzer V8.4.0
OSWatcher Analyzer Written by Oracle Center of Expertise
Copyright (c)  2019 by Oracle Corporation

Parsing Data. Please Wait...

Scanning file headers for version and platform info...


Parsing file orcl19x_pidstat_21.05.29.2200.dat ...

Parsing file orcl19x_iostat_21.05.29.2200.dat ...
This directory already exists. Rewriting...

Parsing file orcl19x_vmstat_21.05.29.2200.dat ...

Parsing file orcl19x_netstat_21.05.29.2200.dat ...

Parsing file orcl19x_top_21.05.29.2200.dat ...

Parsing file orcl19x_ps_21.05.29.2200.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 61 to Display Individual OS Process I/O RPS Graphs
Enter 62 to Display Individual OS Process I/O WPS Graphs
Enter 63 to Display Individual OS Process Percent User CPU Graphs
Enter 64 to Display Individual OS Process Percent System CPU Graphs
Enter 65 to Display Individual OS Process Percent Total CPU (User + System) Graphs
Enter 66 to Display Individual OS Process Percent Memory Graphs

Enter GP to Generate Individual Process Profile
Enter GC to Generate All CPU Gif Files
Enter GM to Generate All Memory Gif Files
Enter GD to Generate All Disk Gif Files
Enter GN to Generate All Network Gif Files

Enter L to Specify Alternate Location of Gif Directory
Enter Z to Zoom Graph Time Scale (Does not change analysis dataset)
Enter B to Returns to Baseline Graph Time Scale (Does not change analysis dataset)
Enter R to Remove Currently Displayed Graphs

Enter X to Export Parsed Data to Flat File
Enter S to Analyze Subset of Data(Changes analysis dataset including graph time scale)
Enter A to Analyze Data
Enter D to Generate DashBoard

Enter Q to Quit Program

I choose GP option to generate individual process report

Please Select an Option:GP

Ospid's Ordered by Average Percent Total CPU:

PID     Average Percent Total CPU    Command

3162                         0.12    ora_pman_orcl19
8883                         0.12    top
8542                         0.13    ora_m000_orcl19
2678                         0.13    pcscd
5232                         0.26    ora_dia0_orcl19

Specify Ospid to View (Q to exit):   8542
Generating file gif/May29221452_1622307537/8542/CPU_PERCENT_USER.gif
Generating file gif/May29221452_1622307537/8542/CPU_PERCENT_SYSTEM.gif
Generating file gif/May29221452_1622307537/8542/CPU_PERCENT_TOTAL.gif
Generating file gif/May29221452_1622307537/8542/MEMORY_PERCENT_TOTAL.gif
Generating file gif/May29221452_1622307537/8542/WPS.gif
Generating file gif/May29221452_1622307537/8542/RPS.gif
Profile has been written to the gif directory.

You will get a gif graph on the process specific CPU consumption

Similarly , look for other options for all parameters

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s