ExaWatcher Trace Purge Before 7 Days Retention

Asset ID:	1-72-2152886.1
Update Date:	2016-06-23
Keywords:

Solution Type Problem Resolution Sure

Solution 2152886.1 : ExaWatcher Trace Purge Before 7 Days Retention

Applies to:

Exadata X3-2 Hardware - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Symptoms

on DB Node the files in directory in Exawatcher get purged without having data for 7 days.

-rw-r----- 1 root root 31934491 Jun 3 03:23 2016_06_03_02_19_36_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 30691215 Jun 3 04:28 2016_06_03_03_24_32_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 30330426 Jun 3 05:32 2016_06_03_04_29_21_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 30531216 Jun 3 06:37 2016_06_03_05_34_10_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 30370985 Jun 3 07:42 2016_06_03_06_39_00_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 30579843 Jun 3 08:47 2016_06_03_07_43_44_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 30287517 Jun 3 09:51 2016_06_03_08_48_29_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 30498279 Jun 3 10:56 2016_06_03_09_53_04_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 30058324 Jun 3 12:01 2016_06_03_10_57_47_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 29887351 Jun 3 13:05 2016_06_03_12_02_24_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 30312573 Jun 3 14:10 2016_06_03_13_07_06_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 29716958 Jun 3 15:15 2016_06_03_14_11_59_TopExaWatcher_mydbnode.mycompany.com.dat.bz2
-rw-r----- 1 root root 101160580 Jun 3 15:20 2016_06_03_15_16_40_TopExaWatcher_mydbnode.mycompany.com.dat

but there's only files for today. It is not keeping files for 7 days default retention period.

Cause

ExaWatcherParserElements.pm

elsif (DetermineSocket() eq 8)
{
#Unit: MB
$DefaultSpaceLimit=6144;
}
else
{
#Unit: MB
$DefaultSpaceLimit=3072;
}

There is a hard limit of 6GB in 8 socket servers and others its set to 3GB.
Review the top file to see why it is so huge. See if its expected because of many processes running or some other issue.

Also, root partition has over 14GB free space. In this case, we can increase the limit by updating the file ExaWatcherParserElements.pm manually, increase SpaceLimit in ExaWatcher.conf and then restart exawatcher.

Solution

Edit this file. /opt/oracle.ExaWatcher/ExaWatcherParserElements.pm

--------------------------------------------

elsif (DetermineSocket() eq 8)
{
  #Unit: MB
  $DefaultSpaceLimit=6144;
}
else
{
  #Unit: MB
  $DefaultSpaceLimit=3072;
}

There is a hard limit of 6GB in 8 socket servers and others its set to 3GB.

In this case, we can increase the limit by updating the file ExaWatcherParserElements.pm manually, increase SpaceLimit in ExaWatcher.conf from 3072 to 6144 and then restart exawatcher.

Attachments

This solution has no attachment