Antivirus software on Oracle server
Does anybody have any experience with this:
Is antivirus software such as McAfee Antivirus going to affect performance of Oracle on Windows 2000 server?
I have a file-based email server with antivirus installed and the McShield on-access scanner is constantly using CPU time whenever a emailbox file is accessed. I wonder if it does the same thing as database file access. I am more concerned about contention for datafile access than stealing CPU cycle.
Most virus software can be configured to ignore files based on various criteria, and commonly the file xtension is one of them. Your data files probably are *.dbf and/or *.ora, so you could configure it to ignore those type for a start.
Maybe you could get the anti-virus software to ignore particular directories instead, though.
Some users are complaining of locking the control files from the anti-virus software. Then you will get error messages in your alert log that Oracle cannot write to the control file.
You have to disable checking of *.dbf, *.log and *.ctl files to avoid that.
Hope that helps,
OCP 8/8i/9i DBA
Visit our Oracle DBA site
Click Here to Expand Forum to Full Width