{"id":7891,"date":"2019-05-06T13:29:06","date_gmt":"2019-05-06T13:29:06","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/introduction-to-oracle-oswatcher-and-reading-logs\/"},"modified":"2026-11-03T19:29:08","modified_gmt":"2026-11-03T19:29:08","slug":"introduction-to-oracle-oswatcher-and-reading-logs","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/introduction-to-oracle-oswatcher-and-reading-logs\/","title":{"rendered":"Introduction to Oracle OSWatcher and reading logs"},"content":{"rendered":"<p><strong>Introduction<\/strong><\/p>\n<p>Oracle\u00a9 OSWatcher is a utility that collects data from commands such as&nbsp;<em>vmstat<\/em>, <em>iostat<\/em>, <em>top<\/em>, <em>ps<\/em>, <em>netstat<\/em>, HP-UX\u00a9 <em>sar<\/em>, and Linux\u00a9<br \/>\n<em>meminfo<\/em>. OSWatcher archives the data files, automatically looks for issues, and helps&nbsp;to determine the root cause of the issues, if possible.<\/p>\n<p>On an hourly basis, OSWatcher collects operating system (OS) statistics in the background<br \/>\nby using the following OS commands:<\/p>\n<p>&#8211; CPU<br \/>\n&#8211; Memory<br \/>\n&#8211; Disk I\/O<\/p>\n<p>OSWatcher writes the files to <strong>$TFA_HOME\/repository\/suptools\/walhall\/oswbb\/oracle\/archive\/<\/strong>.<\/p>\n<p>Because no automatic housekeeping exists, you should create a cron job to&nbsp;automatically delete files older than some number of days to clean up the OS&nbsp; statistics. For example, your cleanup cron job might run the following command&nbsp;to remove files older than 10 days:<\/p>\n<p><em>&nbsp; find $TFA_HOME\/repository\/suptools\/walhall\/oswbb\/oracle\/archive -name &#8220;*.*&#8221; -mtime +10 -exec rm -f {} \\;<\/em><\/p>\n<p><strong>Read the oswiostat log output<\/strong><\/p>\n<p>If <em>iostat<\/em>&nbsp;is installed and the OSWatcher user has privileges to run the utility,&nbsp;the OSWatcher logs collect and archive output on an hourly basis, by default,&nbsp;from the <em>iostat<\/em>&nbsp;command.<em>iostat<\/em>, which is used for monitoring system input and output device load, collects the&nbsp;following information:<\/p>\n<ul>\n<li>&nbsp; &nbsp;The time<\/li>\n<li>&nbsp; &nbsp;The physical disks and their average data transfer rate<\/li>\n<\/ul>\n<p><strong>Output examples<\/strong><\/p>\n<p>The oswiostat log file includes the following data:<\/p>\n<ul>\n<li><em>device<\/em>: Device name<\/li>\n<li>&nbsp;r\/s: Reads per second<\/li>\n<li>&nbsp;w\/s: Writes per second<\/li>\n<li>&nbsp;rsec\/s: Kilobytes read per second<\/li>\n<li>&nbsp;wsec\/s`: Kilobytes written per second<\/li>\n<li>&nbsp;avgrq-sz: Average number of transactions waiting for service<\/li>\n<li>&nbsp;avgqu-sz: Average number of transactions actively being serviced<\/li>\n<li>&nbsp;%util: Percent of time that the disk is busy<\/li>\n<\/ul>\n<p>\nFollowing are two examples of `oswiostat` logs, which were taken seven hours apart:<\/p>\n<p>At a slow time:<\/p>\n<p>&nbsp; &nbsp; Time: 00:01:09<\/p>\n<p>&nbsp; &nbsp; avg-cpu: &nbsp;%user &nbsp; %nice %system %iowait &nbsp;%steal &nbsp; %idle<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5.22 &nbsp; &nbsp;0.01 &nbsp; &nbsp;1.77 &nbsp; &nbsp;0.10 &nbsp; &nbsp;0.00 &nbsp; 92.90<\/p>\n<p>&nbsp; &nbsp; Device: &nbsp; &nbsp; &nbsp; &nbsp; rrqm\/s &nbsp; wrqm\/s &nbsp; r\/s &nbsp; w\/s &nbsp; rsec\/s &nbsp; wsec\/s avgrq-sz avgqu-sz &nbsp; await &nbsp;svctm &nbsp;%util<\/p>\n<p>&nbsp; &nbsp; sda &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10.24 &nbsp; 101.92 10.28 29.60 &nbsp; 569.53 &nbsp;1057.09 &nbsp; &nbsp;40.79 &nbsp; &nbsp; 0.21 &nbsp; &nbsp;5.30 &nbsp; 0.53 &nbsp; 2.11<br \/>\n&nbsp; &nbsp; sda1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.00 &nbsp;0.00 &nbsp; &nbsp; 0.17 &nbsp; &nbsp; 0.00 &nbsp; 138.66 &nbsp; &nbsp; 0.00 &nbsp; 12.37 &nbsp; 3.45 &nbsp; 0.00<br \/>\n&nbsp; &nbsp; sda2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10.24 &nbsp; 101.92 10.28 29.57 &nbsp; 569.36 &nbsp;1057.09 &nbsp; &nbsp;40.81 &nbsp; &nbsp; 0.21 &nbsp; &nbsp;5.30 &nbsp; 0.53 &nbsp; 2.11<br \/>\n&nbsp; &nbsp; dm-0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;1.72 77.98 &nbsp; &nbsp;75.95 &nbsp; 623.85 &nbsp; &nbsp; 8.78 &nbsp; &nbsp; 1.20 &nbsp; 14.99 &nbsp; 0.08 &nbsp; 0.67<br \/>\n&nbsp; &nbsp; dm-1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.46 &nbsp;2.37 &nbsp; &nbsp; 3.80 &nbsp; &nbsp;18.94 &nbsp; &nbsp; 8.04 &nbsp; &nbsp; 0.01 &nbsp; &nbsp;2.71 &nbsp; 0.29 &nbsp; 0.08<br \/>\n&nbsp; &nbsp; dm-2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;7.44 50.74 &nbsp; 278.30 &nbsp; 410.79 &nbsp; &nbsp;11.84 &nbsp; &nbsp; 0.72 &nbsp; 12.30 &nbsp; 0.23 &nbsp; 1.33<br \/>\n&nbsp; &nbsp; dm-3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.00 &nbsp;0.00 &nbsp; &nbsp; 0.15 &nbsp; &nbsp; 0.00 &nbsp; 509.61 &nbsp; &nbsp; 0.00 &nbsp; 46.78 &nbsp; 7.53 &nbsp; 0.00<br \/>\n&nbsp; &nbsp; dm-4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.49 &nbsp;0.00 &nbsp; 117.41 &nbsp; &nbsp; 0.02 &nbsp; 238.95 &nbsp; &nbsp; 0.00 &nbsp; &nbsp;1.94 &nbsp; 1.05 &nbsp; 0.05<br \/>\n&nbsp; &nbsp; dm-5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.05 &nbsp;0.00 &nbsp; &nbsp;10.84 &nbsp; &nbsp; 0.00 &nbsp; 230.78 &nbsp; &nbsp; 0.00 &nbsp; &nbsp;2.58 &nbsp; 1.34 &nbsp; 0.01<br \/>\n&nbsp; &nbsp; dm-6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.00 &nbsp;0.00 &nbsp; &nbsp; 0.10 &nbsp; &nbsp; 0.00 &nbsp; 479.96 &nbsp; &nbsp; 0.00 &nbsp; 54.94 &nbsp; 8.70 &nbsp; 0.00<\/p>\n<p>At a busy time:<\/p>\n<p>&nbsp; &nbsp; Time: 07:32:57<\/p>\n<p>&nbsp; &nbsp; avg-cpu: &nbsp;%user &nbsp; %nice %system %iowait &nbsp;%steal &nbsp; %idle<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8.16 &nbsp; &nbsp;0.00 &nbsp; 70.29 &nbsp; 21.55 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00<\/p>\n<p>&nbsp; &nbsp; Device: &nbsp; &nbsp; &nbsp; &nbsp; rrqm\/s &nbsp; wrqm\/s &nbsp; r\/s &nbsp; w\/s &nbsp; rsec\/s &nbsp; wsec\/s avgrq-sz avgqu-sz &nbsp; await &nbsp;svctm &nbsp;%util<\/p>\n<p>&nbsp; &nbsp; sda &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 163.40 &nbsp; &nbsp; 7.73 2074.74 53.95 73642.61 &nbsp; 493.47 &nbsp; &nbsp;34.83 &nbsp; 107.13 &nbsp; 50.07 &nbsp; 0.47 100.07<br \/>\n&nbsp; &nbsp; sda1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.00 &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp;0.00 &nbsp; 0.00 &nbsp; 0.00<br \/>\n&nbsp; &nbsp; sda2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;163.40 &nbsp; &nbsp; 7.73 2074.74 53.95 73642.61 &nbsp; 493.47 &nbsp; &nbsp;34.83 &nbsp; 107.13 &nbsp; 50.07 &nbsp; 0.47 100.07<br \/>\n&nbsp; &nbsp; dm-0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 201.03 &nbsp;0.86 &nbsp;8412.37 &nbsp; &nbsp; 6.87 &nbsp; &nbsp;41.70 &nbsp; &nbsp;58.68 &nbsp;281.80 &nbsp; 4.96 100.07<br \/>\n&nbsp; &nbsp; dm-1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 180.76 26.46 &nbsp;1446.05 &nbsp; 211.68 &nbsp; &nbsp; 8.00 &nbsp; &nbsp;25.24 &nbsp;119.01 &nbsp; 4.83 100.07<br \/>\n&nbsp; &nbsp; dm-2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 1868.90 34.54 63913.40 &nbsp; 276.29 &nbsp; &nbsp;33.72 &nbsp; 332.23 &nbsp;172.22 &nbsp; 0.53 100.09<br \/>\n&nbsp; &nbsp; dm-3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.00 &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp;0.00 &nbsp; 0.00 &nbsp; 0.00<br \/>\n&nbsp; &nbsp; dm-4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.00 &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp;0.00 &nbsp; 0.00 &nbsp; 0.00<br \/>\n&nbsp; &nbsp; dm-5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.00 &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp;0.00 &nbsp; 0.00 &nbsp; 0.00<br \/>\n&nbsp; &nbsp; dm-6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp;0.00 &nbsp;0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp;0.00 &nbsp; 0.00 &nbsp; 0.00<\/p>\n<p><em><a href=\"https:\/\/www.dbas-oracle.com\/2013\/05\/How-to-Analyze-or-Read-OS-Watcher-Output-in-three-easy-steps-With-Example.html\">Image Source<\/a><\/em><\/p>\n<p>\nThe snapshot from midnight shows good performance, and the one from 7:32 AM shows&nbsp;poor performance. Note the following indications of poor performance in the&nbsp;second snapshot:&nbsp;<\/p>\n<ul>\n<li>Several disks are 100% busy, as seen in the `%util` column.<\/li>\n<li>The `<em>r\/s<\/em>` column shows a very high number of reads per second.<\/li>\n<li>&nbsp;The `avg-cpu %idle` statistic shows the system is 0% idle versus 92% idle in the earlier snapshot.<\/li>\n<\/ul>\n<p><strong>Read the mpstat log output<\/strong><\/p>\n<p>If <em>mpstat<\/em>&nbsp;is installed and the OSWatcher user has privileges to run the utility,&nbsp;the OSWatcher logs collect and archive output on an hourly basis, by default,&nbsp;from the `mpstat` command. Database administrators use this command to&nbsp;monitor the central processing unit (CPU) utilization.<\/p>\n<p><strong>Output examples<\/strong><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><em>CPU<\/em>: Which CPUs. `all` includes stats from all available CPUs in the system.<\/li>\n<li><em>%user<\/em>`: The percent of the CPUs used by USER programs<\/li>\n<li><em>%sys<\/em>: The percent of the CPUs used by system programs<\/li>\n<li><em>iowait<\/em>: The percent of the CPUs consumed by IO waits<\/li>\n<li><em>idle<\/em>: The percent of idle system resources<\/li>\n<\/ul>\n<p>Following are two examples of `mpstat` logs taken one hour apart:<\/p>\n<p>At a slow time:<\/p>\n<p>&nbsp; &nbsp; zzz ***Tue Apr 23 06:13:44 EDT 2013 Sample interval: 5 seconds<\/p>\n<p>&nbsp; &nbsp; Linux 2.6.32-400.21.1.el5uek (remote.database.com) &nbsp; &nbsp; 04\/23\/13<\/p>\n<p>&nbsp; &nbsp; 06:13:44 &nbsp; &nbsp; CPU &nbsp; %user &nbsp; %nice &nbsp; &nbsp;%sys %iowait &nbsp; &nbsp;%irq &nbsp; %soft &nbsp;%steal &nbsp; %idle &nbsp; &nbsp;intr\/s<\/p>\n<p>&nbsp; &nbsp; 06:13:49 &nbsp; &nbsp; all &nbsp; &nbsp;6.26 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.32 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.01 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; 92.39 &nbsp;36448.70<br \/>\n&nbsp; &nbsp; 06:13:54 &nbsp; &nbsp; all &nbsp; &nbsp;8.17 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.92 &nbsp; &nbsp;0.01 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.05 &nbsp; &nbsp;0.00 &nbsp; 89.86 &nbsp;38918.09<br \/>\n&nbsp; &nbsp; 06:13:59 &nbsp; &nbsp; all &nbsp; &nbsp;8.11 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.18 &nbsp; &nbsp;0.01 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.05 &nbsp; &nbsp;0.00 &nbsp; 90.65 &nbsp;40989.86<br \/>\n&nbsp; &nbsp; 06:14:04 &nbsp; &nbsp; all &nbsp; &nbsp;8.04 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.25 &nbsp; &nbsp;0.06 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.05 &nbsp; &nbsp;0.00 &nbsp; 90.61 &nbsp;40242.86<br \/>\n&nbsp; &nbsp; 06:14:09 &nbsp; &nbsp; all &nbsp; &nbsp;6.62 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.27 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.05 &nbsp; &nbsp;0.00 &nbsp; 92.04 &nbsp;37460.32<br \/>\n&nbsp; &nbsp; 06:14:14 &nbsp; &nbsp; all &nbsp; &nbsp;7.56 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.47 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; 90.94 &nbsp;37288.67<br \/>\n&nbsp; &nbsp; 06:14:19 &nbsp; &nbsp; all &nbsp; &nbsp;7.19 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.21 &nbsp; &nbsp;0.14 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; 91.44 &nbsp;36947.91<br \/>\n&nbsp; &nbsp; 06:14:24 &nbsp; &nbsp; all &nbsp; &nbsp;6.50 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.02 &nbsp; &nbsp;0.01 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; 92.45 &nbsp;35792.86<br \/>\n&nbsp; &nbsp; 06:14:29 &nbsp; &nbsp; all &nbsp; &nbsp;7.28 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.82 &nbsp; &nbsp;0.01 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; 90.87 &nbsp;36795.42<br \/>\n&nbsp; &nbsp; 06:14:34 &nbsp; &nbsp; all &nbsp; &nbsp;7.37 &nbsp; &nbsp;0.02 &nbsp; &nbsp;1.20 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.01 &nbsp; &nbsp;0.00 &nbsp; 91.37 &nbsp;36818.80<br \/>\n&nbsp; &nbsp; 06:14:39 &nbsp; &nbsp; all &nbsp; &nbsp;7.41 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.05 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; 91.49 &nbsp;36874.90<br \/>\n&nbsp; &nbsp; 06:14:44 &nbsp; &nbsp; all &nbsp; &nbsp;7.15 &nbsp; &nbsp;0.01 &nbsp; &nbsp;1.62 &nbsp; &nbsp;0.04 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; 91.16 &nbsp;35904.77<br \/>\n&nbsp; &nbsp; 06:14:49 &nbsp; &nbsp; all &nbsp; &nbsp;7.21 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.22 &nbsp; &nbsp;0.14 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.02 &nbsp; &nbsp;0.00 &nbsp; 91.41 &nbsp;38867.73<br \/>\n&nbsp; &nbsp; 06:14:54 &nbsp; &nbsp; all &nbsp; &nbsp;7.31 &nbsp; &nbsp;0.00 &nbsp; &nbsp;1.00 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.03 &nbsp; &nbsp;0.00 &nbsp; 91.65 &nbsp;39378.74<\/p>\n<p>&nbsp;<\/p>\n<p>At a busy time:<\/p>\n<p>&nbsp; &nbsp; zzz ***Tue Apr 23 07:23:02 EDT 2013 Sample interval: 5 seconds<\/p>\n<p>&nbsp; &nbsp; Linux 2.6.32-400.21.1.el5uek (remote.database.com) &nbsp; &nbsp; 04\/23\/13<\/p>\n<p>&nbsp; &nbsp; 07:24:20 &nbsp; &nbsp; CPU &nbsp; %user &nbsp; %nice &nbsp; &nbsp;%sys %iowait &nbsp; &nbsp;%irq &nbsp; %soft &nbsp;%steal &nbsp; %idle &nbsp; &nbsp;intr\/s<\/p>\n<p>&nbsp; &nbsp; 07:24:25 &nbsp; &nbsp; all &nbsp; &nbsp;2.74 &nbsp; &nbsp;0.00 &nbsp; 97.16 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.10 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;39066.67<br \/>\n&nbsp; &nbsp; 07:24:30 &nbsp; &nbsp; all &nbsp; &nbsp;3.06 &nbsp; &nbsp;0.00 &nbsp; 96.87 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.07 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;37637.52<br \/>\n&nbsp; &nbsp; 07:24:37 &nbsp; &nbsp; all &nbsp; &nbsp;3.13 &nbsp; &nbsp;0.00 &nbsp; 96.79 &nbsp; &nbsp;0.01 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.07 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;36788.64<br \/>\n&nbsp; &nbsp; 07:24:42 &nbsp; &nbsp; all &nbsp; &nbsp;2.69 &nbsp; &nbsp;0.00 &nbsp; 97.17 &nbsp; &nbsp;0.05 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.09 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;38270.04<br \/>\n&nbsp; &nbsp; 07:24:48 &nbsp; &nbsp; all &nbsp; &nbsp;3.86 &nbsp; &nbsp;0.01 &nbsp; 94.92 &nbsp; &nbsp;1.02 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.20 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;43247.39<br \/>\n&nbsp; &nbsp; 07:24:53 &nbsp; &nbsp; all &nbsp; &nbsp;3.51 &nbsp; &nbsp;0.00 &nbsp; 96.19 &nbsp; &nbsp;0.20 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.11 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;39887.45<br \/>\n&nbsp; &nbsp; 07:24:59 &nbsp; &nbsp; all &nbsp; &nbsp;4.22 &nbsp; &nbsp;0.00 &nbsp; 93.51 &nbsp; &nbsp;2.12 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.15 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;40638.08<br \/>\n&nbsp; &nbsp; 07:25:04 &nbsp; &nbsp; all &nbsp; &nbsp;6.26 &nbsp; &nbsp;0.00 &nbsp; 85.04 &nbsp; &nbsp;8.56 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.13 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;41915.79<br \/>\n&nbsp; &nbsp; 07:25:09 &nbsp; &nbsp; all &nbsp; &nbsp;8.69 &nbsp; &nbsp;0.00 &nbsp; 67.31 &nbsp; 23.85 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.11 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.03 &nbsp;44586.56<br \/>\n&nbsp; &nbsp; 07:25:15 &nbsp; &nbsp; all &nbsp; &nbsp;8.09 &nbsp; &nbsp;0.00 &nbsp; 80.62 &nbsp; 11.17 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.12 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;44321.66<br \/>\n&nbsp; &nbsp; 07:25:21 &nbsp; &nbsp; all &nbsp; &nbsp;7.18 &nbsp; &nbsp;0.00 &nbsp; 71.95 &nbsp; 20.80 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.07 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;35399.65<br \/>\n&nbsp; &nbsp; 07:25:26 &nbsp; &nbsp; all &nbsp; &nbsp;6.69 &nbsp; &nbsp;0.00 &nbsp; 68.20 &nbsp; 24.97 &nbsp; &nbsp;0.01 &nbsp; &nbsp;0.12 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;38734.99<br \/>\n&nbsp; &nbsp; 07:25:31 &nbsp; &nbsp; all &nbsp; &nbsp;7.11 &nbsp; &nbsp;0.01 &nbsp; 74.71 &nbsp; 18.09 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.08 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;36695.68<br \/>\n&nbsp; &nbsp; 07:25:36 &nbsp; &nbsp; all &nbsp; &nbsp;7.46 &nbsp; &nbsp;0.00 &nbsp; 14.17 &nbsp; 78.20 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.05 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.13 &nbsp;32934.53<br \/>\n&nbsp; &nbsp; 07:25:50 &nbsp; &nbsp; all &nbsp; &nbsp;9.71 &nbsp; &nbsp;0.00 &nbsp; 23.99 &nbsp; 66.24 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.05 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;33617.64<br \/>\n&nbsp; &nbsp; 07:25:56 &nbsp; &nbsp; all &nbsp; &nbsp;7.80 &nbsp; &nbsp;0.00 &nbsp; 85.97 &nbsp; &nbsp;6.13 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.10 &nbsp; &nbsp;0.00 &nbsp; &nbsp;0.00 &nbsp;41234.83<\/p>\n<p>The snapshot from 06:13 shows good performance, and the one from 7:32 AM shows&nbsp;poor performance. Note the following indications of poor performance in the&nbsp;second snapshot:<\/p>\n<ul>\n<li><em>&nbsp;The `%sys` column shows peak utilization of 97.17.<\/em><\/li>\n<li><em>&nbsp;The `%iowait` column shows a peak utilization of 78.20.<\/em><\/li>\n<\/ul>\n<p><strong>Read top output<\/strong><\/p>\n<p>The `<em>top<\/em>` command provides an hourly snapshot of processor activity.&nbsp;The log shows processes listed in the descending order of CPU utilization so&nbsp;that the process using the most CPU is listed first.<\/p>\n<p>In cases when CPU utilization on the system suddenly increases and number of&nbsp;processes hasn&#8217;t changed, `<em>top<\/em>` can help identify the issue.<\/p>\n<p><strong>Output examples<\/strong><\/p>\n<p>Consider the following scenario, where the CPU spikes even though load did not<br \/>\nincrease:<\/p>\n<p>&nbsp; &nbsp; zzz ***Tue Apr 23 03:13:44 EDT 2013 Sample interval: 5 seconds. All measurements in KB (1024 bytes)<\/p>\n<p>&nbsp; &nbsp; top &#8211; 04:13:44 up 22 days, 21:12, 10 users, &nbsp;load average: 65.80, 169.78, 117.65<\/p>\n<p>&nbsp; &nbsp; Tasks: 2297 total, &nbsp; 4 running, 2229 sleeping, &nbsp; 0 stopped, &nbsp;64 zombie<\/p>\n<p>&nbsp; &nbsp; Cpu0 &nbsp;: 12.7%us, &nbsp;2.6%sy, &nbsp;0.0%ni, 84.2%id, &nbsp;0.5%wa, &nbsp;0.0%hi, &nbsp;0.0%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu1 &nbsp;: &nbsp;6.7%us, &nbsp;2.0%sy, &nbsp;0.0%ni, 91.1%id, &nbsp;0.1%wa, &nbsp;0.0%hi, &nbsp;0.1%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu2 &nbsp;: &nbsp;6.4%us, &nbsp;1.7%sy, &nbsp;0.0%ni, 91.8%id, &nbsp;0.1%wa, &nbsp;0.0%hi, &nbsp;0.0%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu3 &nbsp;: &nbsp;5.5%us, &nbsp;1.3%sy, &nbsp;0.0%ni, 93.1%id, &nbsp;0.1%wa, &nbsp;0.0%hi, &nbsp;0.0%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu4 &nbsp;: &nbsp;7.6%us, &nbsp;1.6%sy, &nbsp;0.0%ni, 90.7%id, &nbsp;0.0%wa, &nbsp;0.0%hi, &nbsp;0.0%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu5 &nbsp;: &nbsp;5.3%us, &nbsp;1.1%sy, &nbsp;0.0%ni, 93.5%id, &nbsp;0.0%wa, &nbsp;0.0%hi, &nbsp;0.0%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu6 &nbsp;: 11.8%us, &nbsp;2.7%sy, &nbsp;0.0%ni, 85.3%id, &nbsp;0.1%wa, &nbsp;0.0%hi, &nbsp;0.1%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu7 &nbsp;: &nbsp;7.0%us, &nbsp;2.2%sy, &nbsp;0.0%ni, 90.6%id, &nbsp;0.1%wa, &nbsp;0.0%hi, &nbsp;0.1%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu8 &nbsp;: &nbsp;5.8%us, &nbsp;1.5%sy, &nbsp;0.0%ni, 91.8%id, &nbsp;0.8%wa, &nbsp;0.0%hi, &nbsp;0.1%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu9 &nbsp;: &nbsp;8.0%us, &nbsp;1.7%sy, &nbsp;0.0%ni, 90.0%id, &nbsp;0.1%wa, &nbsp;0.0%hi, &nbsp;0.2%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu10 : &nbsp;3.8%us, &nbsp;1.2%sy, &nbsp;0.0%ni, 94.9%id, &nbsp;0.1%wa, &nbsp;0.0%hi, &nbsp;0.0%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; Cpu11 : &nbsp;3.6%us, &nbsp;1.0%sy, &nbsp;0.0%ni, 95.3%id, &nbsp;0.0%wa, &nbsp;0.0%hi, &nbsp;0.0%si, &nbsp;0.0%st<\/p>\n<p>&nbsp; &nbsp; Mem: &nbsp;99060540k total, 91969324k used, &nbsp;7091216k free, &nbsp; &nbsp;84044k buffers<br \/>\n&nbsp; &nbsp; Swap: 25165816k total, 17797404k used, &nbsp;7368412k free, &nbsp; 609612k cached<\/p>\n<p>&nbsp; &nbsp; &nbsp;PID USER &nbsp; &nbsp; &nbsp;PR &nbsp;NI &nbsp;VIRT &nbsp;RES &nbsp;SHR S %CPU %MEM &nbsp; &nbsp;TIME+ &nbsp;COMMAND<\/p>\n<p>&nbsp; &nbsp; 20343 oracle &nbsp; &nbsp;20 &nbsp; 0 13.4g &nbsp;10g 5864 R 98.4 10.7 &nbsp;18:56.54 oraclevntrd2 (LOCAL=NO)<br \/>\n&nbsp; &nbsp; 30180 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 11872 2312 &nbsp;656 R 98.4 &nbsp;0.0 &nbsp; 0:00.68 \/bin\/netstat -n -p -l<br \/>\n&nbsp; &nbsp; &nbsp;6568 root &nbsp; &nbsp; &nbsp;39 &nbsp;19 &nbsp; &nbsp; 0 &nbsp; &nbsp;0 &nbsp; &nbsp;0 R 89.9 &nbsp;0.0 263:39.04 [kipmi0]<br \/>\n&nbsp; &nbsp; 30262 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 23704 3116 1048 R 11.9 &nbsp;0.0 &nbsp; 0:00.15 \/usr\/bin\/top -b -d 5 -n 720<br \/>\n&nbsp; &nbsp; &nbsp;4921 root &nbsp; &nbsp; &nbsp;RT &nbsp; 0 &nbsp;247m &nbsp;86m &nbsp;55m S &nbsp;6.8 &nbsp;0.1 328:08.44 \/u01\/app\/11.2.0.3\/grid\/bin\/osysmond.bin<br \/>\n&nbsp; &nbsp; 28116 oracle &nbsp; &nbsp;20 &nbsp; 0 2623m &nbsp;71m &nbsp;14m S &nbsp;6.8 &nbsp;0.1 &nbsp;51:51.62 \/u01\/app\/11.2.0.3\/grid\/bin\/oraagent.bin<br \/>\n&nbsp; &nbsp; &nbsp;4970 grid &nbsp; &nbsp; &nbsp;RT &nbsp; 0 &nbsp;359m 176m &nbsp;54m S &nbsp;5.1 &nbsp;0.2 157:05.89 \/u01\/app\/11.2.0.3\/grid\/bin\/ocssd.bin<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp;64 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 &nbsp; &nbsp; 0 &nbsp; &nbsp;0 &nbsp; &nbsp;0 S &nbsp;1.7 &nbsp;0.0 &nbsp; 4:39.22 [ksoftirqd\/20]<br \/>\n&nbsp; &nbsp; &nbsp;4903 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 &nbsp;367m &nbsp;20m &nbsp;13m S &nbsp;1.7 &nbsp;0.0 &nbsp;26:09.97 \/u01\/app\/11.2.0.3\/grid\/bin\/orarootagent.bin<br \/>\n&nbsp; &nbsp; &nbsp;6496 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 1274m &nbsp;15m &nbsp;11m S &nbsp;1.7 &nbsp;0.0 &nbsp;28:27.53 \/u01\/app\/11.2.0.3\/grid\/bin\/orarootagent.bin<br \/>\n&nbsp; &nbsp; &nbsp;6535 oracle &nbsp; &nbsp;20 &nbsp; 0 1830m 263m 4620 S &nbsp;1.7 &nbsp;0.3 &nbsp;88:05.31 \/u01\/app\/oracle\/product\/agent12c\/core\/12.1.0.2.0\/jdk\/bin\/java -Xmx128M -server -Djava.secu<br \/>\n&nbsp; &nbsp; &nbsp;7803 oracle &nbsp; &nbsp;-2 &nbsp; 0 1266m &nbsp;11m 4068 S &nbsp;1.7 &nbsp;0.0 &nbsp; 9:15.42 ora_lms0_oradb2<br \/>\n&nbsp; &nbsp; &nbsp;7874 oracle &nbsp; &nbsp;-2 &nbsp; 0 1266m &nbsp;15m 4188 S &nbsp;1.7 &nbsp;0.0 &nbsp; 9:16.20 ora_lms0_oradb2<br \/>\n&nbsp; &nbsp; &nbsp;7999 oracle &nbsp; &nbsp;20 &nbsp; 0 1284m &nbsp;10m 3292 S &nbsp;1.7 &nbsp;0.0 &nbsp; 2:49.08 ora_lmd0_oradb2<br \/>\n&nbsp; &nbsp; &nbsp;8297 oracle &nbsp; &nbsp;20 &nbsp; 0 1230m 3368 2864 S &nbsp;1.7 &nbsp;0.0 &nbsp; 0:39.95 ora_pmon_oradb2<br \/>\n&nbsp; &nbsp; &nbsp;8333 oracle &nbsp; &nbsp;-2 &nbsp; 0 1252m 2380 2108 S &nbsp;1.7 &nbsp;0.0 &nbsp;13:19.99 ora_vktm_bid2<br \/>\n&nbsp; &nbsp; &nbsp;8443 oracle &nbsp; &nbsp;-2 &nbsp; 0 1252m 2340 2096 S &nbsp;1.7 &nbsp;0.0 &nbsp;13:21.86 ora_vktm_oradb2<br \/>\n&nbsp; &nbsp; &nbsp;8535 oracle &nbsp; &nbsp;20 &nbsp; 0 1253m 2712 2412 S &nbsp;1.7 &nbsp;0.0 &nbsp; 0:14.28 ora_dskm_oradb2<br \/>\n&nbsp; &nbsp; &nbsp;8727 oracle &nbsp; &nbsp;-2 &nbsp; 0 1266m &nbsp;11m 3656 S &nbsp;1.7 &nbsp;0.0 &nbsp; 9:01.37 ora_lms0_im1d2<br \/>\n&nbsp; &nbsp; &nbsp;8905 oracle &nbsp; &nbsp;20 &nbsp; 0 1267m &nbsp;13m 3468 S &nbsp;1.7 &nbsp;0.0 &nbsp; 9:52.75 ora_dia0_pstd2<br \/>\n&nbsp;<\/p>\n<p><strong>Analysis of the log:<\/strong><\/p>\n<p>Line `zzz ***Tue Apr 23 03:13:44 EDT 2013 Sample interval: 5 seconds. All measurements in KB (1024 bytes)`<br \/>\nidentifies the time that the log captured the statistics.<\/p>\n<p>Line `top &#8211; 04:13:44 up 22 days, 21:12, 10 users` indicates that system has been<br \/>\nrunning for 22 days since the last reboot.<\/p>\n<p>Line `load average:<em> 65.80, 169.78, 117.65<\/em>` shows the average number of processes&nbsp;in the run queue for the last one, five, and fifteen minutes. The higher the&nbsp;average load, the busier the system is. Significant increases in load average&nbsp;might indicate a problem. For example, the preceding log indicates a busy time&nbsp;compared to a log from seven minutes later, based on the load average numbers:&nbsp;<\/p>\n<p>`<em>top &#8211; 04:20:53 up 22 days, 21:19, 10 users, &nbsp;load average: 2.93, 43.22, 75.56<\/em>`<\/p>\n<p>Line `<em>Tasks: 2297 total, &nbsp; 4 running, 2229 sleeping, &nbsp; 0 stopped, &nbsp;64 zombie<\/em>`:<br \/>\nAt the time of this snapshot, there were 2297 processes, 2229 were sleeping,&nbsp;that is blocked by I\/O or a system call, and 4 were<br \/>\nrunning or assigned to a CPU. &nbsp;The number of running processes can never exceed&nbsp;the number of CPUs. An additional 64 processes are zombies, that is they are dead,&nbsp;but the system hasn&#8217;t completely cleaned them up. The number of processes varies,&nbsp;but if the number suddenly increases or decreases, that might indicate a problem.<\/p>\n<p>Line `Mem: &nbsp;99060540k total, 91969324k used, &nbsp;7091216k free, &nbsp; &nbsp;84044k buffers`<br \/>\nshows how much random access memory (RAM) in kilobytes is in use and is free.<br \/>\nPay attention to how this changes over time so you can identify problems.<\/p>\n<p>Line `<em>Swap: 25165816k total, 17797404k used, &nbsp;7368412k free, &nbsp; 609612k cached<\/em>`:<br \/>\nIf RAM is exhausted, the system switches to swap memory. When swap memory use is<br \/>\nconsistently more than about 40% of RAM, you should consider increasing RAM.<br \/>\nHigh swap usage negatively affects performance. If it reaches 100%, the system<br \/>\nmight reboot.<br \/>\n&nbsp;<\/p>\n<p>The following CPU lines show the number and utilization of the 12 CPUs in this<br \/>\nsystem:<\/p>\n<p>&nbsp; &nbsp; Cpu0 &nbsp;: 12.7%us, &nbsp;2.6%sy, &nbsp;0.0%ni, 84.2%id, &nbsp;0.5%wa, &nbsp;0.0%hi, &nbsp;0.0%si, &nbsp;0.0%st<br \/>\n&nbsp; &nbsp; &#8230;<br \/>\n&nbsp; &nbsp; Cpu11 : &nbsp;3.6%us, &nbsp;1.0%sy, &nbsp;0.0%ni, 95.3%id, &nbsp;0.0%wa, &nbsp;0.0%hi, &nbsp;0.0%si, &nbsp;0.0%st<\/p>\n<p>\nThe following process lines show details of the processes running at the time of<br \/>\nthe snapshot:<\/p>\n<p>&nbsp; &nbsp; &nbsp;PID USER &nbsp; &nbsp; &nbsp;PR &nbsp;NI &nbsp;VIRT &nbsp;RES &nbsp;SHR S %CPU %MEM &nbsp; &nbsp;TIME+ &nbsp;COMMAND<\/p>\n<p>&nbsp; &nbsp; 20343 oracle &nbsp; &nbsp;20 &nbsp; 0 13.4g &nbsp;10g 5864 R 98.4 10.7 &nbsp;18:56.54 oraclevntrd2 (LOCAL=NO)<br \/>\n&nbsp; &nbsp; 30180 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 11872 2312 &nbsp;656 R 98.4 &nbsp;0.0 &nbsp; 0:00.68 \/bin\/netstat -n -p -l<br \/>\n&nbsp; &nbsp; &nbsp;6568 root &nbsp; &nbsp; &nbsp;39 &nbsp;19 &nbsp; &nbsp; 0 &nbsp; &nbsp;0 &nbsp; &nbsp;0 R 89.9 &nbsp;0.0 263:39.04 [kipmi0]<br \/>\n&nbsp; &nbsp; 30262 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 23704 3116 1048 R 11.9 &nbsp;0.0 &nbsp; 0:00.15 \/usr\/bin\/top -b -d 5 -n 720<br \/>\n&nbsp; &nbsp; &#8230;<br \/>\n&nbsp; &nbsp; &nbsp;8727 oracle &nbsp; &nbsp;-2 &nbsp; 0 1266m &nbsp;11m 3656 S &nbsp;1.7 &nbsp;0.0 &nbsp; 9:01.37 ora_lms0_im1d2<br \/>\n&nbsp; &nbsp; &nbsp;8905 oracle &nbsp; &nbsp;20 &nbsp; 0 1267m &nbsp;13m 3468 S &nbsp;1.7 &nbsp;0.0 &nbsp; 9:52.75 ora_dia0_pstd2<br \/>\n&nbsp;<\/p>\n<p>The processes section contains the following information:<\/p>\n<ul>\n<li><em>PID<\/em>`: The OS process ID of the process<\/li>\n<li><em>USER<\/em>`: The owner of the process<\/li>\n<li><em>%CPU<\/em>`: What percent of the CPU is used by the process<\/li>\n<li><em>%MEM<\/em>`: The percentage of memory consumption<\/li>\n<li><em>COMMAND<\/em>`: The executing command<\/li>\n<\/ul>\n<p><strong>Conclusion<\/strong><\/p>\n<p>By using OSWatcher, you can keep an eye on system performance and identify&nbsp;possible problems. For example, check to see if a process is heavily using a&nbsp;CPU for a consistent amount of time. If an SQL command has a high load, then&nbsp;this might be a candidate for tuning. If a process is using a lot of memory,&nbsp;then you might investigate whether this is normal.<\/p>\n<p>There are other stats available in OSWatcher to consider, after looking at CPU,&nbsp;memory, and disk I\/O (such as system load). If you identify a load increase on the&nbsp;system by using OSWatcher analysis, half the battle is won.<br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction to Oracle OSWatcher and reading logs<\/p>\n","protected":false},"author":2,"featured_media":7893,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26543","content_type":"blog","created_by":"10130","authored_on":"2024-01-25T14:29:06+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Suryakanta Sahu, Oracle Applications Database Administrator, Rackspace Technology","seo_description":"Get a thorough understanding of Oracle OSWatcher, its functions, and techniques for reading logs to troubleshoot system issues.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26543-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle","product":"","publisheddate":"2019-05-06T13:29:06","rxt_solutions":"Data, Databases","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Oracle OSWatcher Overview and Log Reading Guide | Rackspace Technology","field_topics":"","field_slug":"introduction-to-oracle-oswatcher-and-reading-logs","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7891","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=7891"}],"version-history":[{"count":1,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7891\/revisions"}],"predecessor-version":[{"id":7892,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7891\/revisions\/7892"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/7893"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=7891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=7891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=7891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}