Skip to main content

Oracle OS Watcher - Start and generate html report

Hi Guys,

OS Watcher is an excellent utility for system performance investigation.

OSWatcher invokes these distinct operating system utilities, each as a distinct background process, as data collectors. These utilities will be supported, or their equivalents, as available for each supported target platform.
  • ps
  • top
  • ifconfig
  • mpstat
  • iostat
  • netstat
  • traceroute
  • vmstat
  • meminfo (Linux Only)
  • slabinfo (Linux Only)

OSWatcher is java program and requires as a minimum java version 1.4.2 or higher. This can run on on any Unix/Windows. An X Windows environment is required because oswbba uses Oracle Chart builder which requires it.

Make sure java path is set

$which java
$<java path>/java

Following will take system snapshot in every 30 seconds and will log last 24 hours data to OS Watcher archive log files.

$cd <OS watcher dir>
$nohup ./startOSWbb.sh 30 24 gzip <OS Watcher file location> &

Without compress

$nohup ./startOSWbb.sh 30 48 NONE /oracle/PB0/oraarch/oswbb/archive &

Stop OS Watcher

./stopOSWbb.sh

This must be executed from X manager session and will generate HTML report. You can set the required memory size for java program, this size depends on how much data you are analyzing. I use 1000M for one-day data, sometime 3000M as well for 3 days.

$<java path>java -jar -Xmx3000M oswbba.jar -i <OS Watcher Archive dir> -B Mar 10 06:00:00 2017 -E Mar 12 08:00:00 2017 -P

-B   --> Begin time of job analysis
-E  --> End time of analysis

More information

Download oswbb732.tar from MOS - 301137.1
OS Watcher User's Guide (Doc ID 1531223.1)


Please write your comments if this helped you and let me know if I can help you further.

Comments

  1. Satyam9 April 2017 at 20:45

    Hi Kanhaiya,
    Thank you very much for detailed explanation about OSWatcher, it's really good stuff to professionals who are working on RAC systems and performance issues.

    We are expecting such kind of useful articles from you.

    ReplyDelete
  2. Kanhaiya Lal10 April 2017 at 01:35

    Thanks for you comments, shall share something more.

    ReplyDelete
  3. Unknown10 April 2017 at 03:43

    Thank you Kanhaiya for the informative article.

    ReplyDelete
  4. Soft Test16 April 2017 at 07:20

    Thanks Kanhaiya!
    Very useful article.

    ReplyDelete
  5. Unknown16 April 2017 at 13:17

    Good one. Useful

    ReplyDelete
  6. Unknown22 June 2017 at 07:55

    Hi Kanhaiya,

    Great detailed info. Thank you so much.

    ReplyDelete
  7. Unknown30 April 2019 at 08:35

    Thanks for sharing.

    ReplyDelete
  8. Satyam6 November 2019 at 06:49

    Thanks Kanhaiya for the detailed explanation on OSWatcher. It's would be useful to understand the system performance.

    ReplyDelete

Post a Comment

Popular posts from this blog

Alter System Checkpoint

Hello Techies, This happens most of the time that you need to add/drop redo log groups in Oracle databases due to any administrative reasons, however, if candidate redo group is in ACTIVE status, then you can't drop it and DBA need to wait until this comes in INACTIVE status to become this group available from drop. Here is the trick. Current status of redo log groups in my test database and you can see highlighted groups in ACTIVE status. In this situation, if DBA need to modify/drop these groups he/she need to wait until this comes in INACTIVE status. SQL> select * from v$log;     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME      NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------...
12 comments
Read more

Oracle Trace File Analyzer (TFA)

Hi Guys, Oracle Trace File Analyzer (TFA) is a powerful diagnostic tool which provides a number of diagnostic tools in a single bundle and making it easy to gather diagnostic information about the Oracle database and Clusterware, which in turn helps with problem resolution when dealing with Oracle Support. Download TFA Install TFA Run a TFA collection. Upload TFA collection to My Oracle Support (MOS) Download TFA. Download the latest version from here .  Install TFA This is recommended that TFA should be installed from " root " OS user which provides the most functionalities and allows it to run in a proactive manner as a daemon, or locally as the Oracle software owner. Here I did this from root to do proactive tool. Unzip the software, create a destination location and install the software using the "-local" flag (if not doing this for RAC). unzip command path is mandatory for installing the TFACTL Locating th...
5 comments
Read more