When an Oracle Data Base is installed and is running on a Linux server, a performance impact may be encountered which is caused by the on-access scanning. This is because during normal operations, many integral DB files are constantly being opened or used in the processing of the data. Sometimes these files are opened and scanned hundreds of times per minute.
On Windows platforms, these files can be excluded using the file extensions. On Linux, this is not an option as file extensions are not used by the operating system. So the file exclusions should be made with the help of the local DB Administrator.
The following sections are covered:
Applies to the following Sophos products and versions
Sophos Anti-Virus for Linux
Sophos Anti-Virus for Linux 9.15.0
Sophos Linux Security 10.4.0
The following table describes the Oracle file types that should be considered for exclusion with reference to their Windows equivalent extension:
File Type |
Description |
Example |
Data |
Oracle data files have an extension of .dbf when found on a Windows platform |
Generally found in:
ORACLE_BASE/oradata/
|
Log |
Have an extension of .log and these will be created when creating or restoring database backup copies |
Generally found in:
ORACLE_BASE/inventory/logs/
|
Redo |
Real-time Oracle execution files and may also have a .log or a .rdo extension on a Windows platform. Redo logs will exist if the Oracle Development toolkit or backup and recovery is used |
|
Control |
Oracle Control files have an extension of .ctl on a Windows platform |
Generally found in:
ORACLE_BASE/oradata/
|
The files included in the above file types should be identified by the local Database Administrator so they can be considered for exclusion.
Exclusions can be made on an individual file name basis or as a block using wildcards and common name attributes. When any exclusions are made, it is recommended to review the file and consider whether a scheduled or named scan needs to be created to check the file or directory regularly.
Note:
SophosEnterprise Console only supports path-based Linux and UNIX exclusions. Other types of exclusion can be directly setup on the managed computers. Regular expressions can be used to exclude file types and files systems.
If you’ve spotted an error or would like to provide feedback on this article, please use the section below to rate and comment on the article.
This is invaluable to us to ensure that we continually strive to give our customers the best information possible.
Related: