Written by: Bert
Wednesday, November 19, 2008 7:29 AM 

1. Exclude Oracle data files directory(s) from all anti-virus and anti-spyware automatic and manual scans. Myself, I exclude the entire “C:\Oracle” directory – where I place all my Oracle files.
    
2. Eliminate all unnecessary background processes (demons) or services. Here are some basic examples (note that your computing environment needs and thus extraneous list will surely vary – so check with your local administrators to be sure and thus safe):  
    
   
   1. Windows XP
      1. ATI Hot Key Poller
      2. Computer Browser
      3. Distributed Link Tracking Client
      4. Error Reporting Service
      5. Indexing Service
      6. Upload Manager
          
   2. Redhat Linux(s)
      1.  anacron / cron
      2.   httpd
      3.   ISDN
      4.   Net FS
      5.   NFS Lock
      6.   Send Mail
          
3. Clean up (i.e. purge) the Oracle logging directory tree. For 9i and 10g, this was subdirectories such as BDUMP and UDUMP under your “admin/SID” directory. Starting with 11g, you need to look at the entire “DIAG” directory. Myself, I use a freeware called CCCleaner to purge all these files such that they don’t accumulate.
    
4. Place the Oracle “DIAG” directory on a RAM Disk. This also has the side effect of automatically purging the files (step #3 above) when the laptop is shutdown.
    
5. Exclude Oracle data files directory(s) from excessive or unnecessary last update timestamp maintenance.
    
   1. Windows

      1. HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\FileSystem\NtfsDisableLastAccessUpdate = 1

   2. Redhat Linux(s)
      1. chattr +A file_name per Oracle control, data and log file
      2. chattr –R +A directory_name per Oracle SID data directory
      3. Edit /etc/fstab for the Oracle Home and/or data file systems
         Example:    /dev/sda6    / home    ext3    defaults,noatime    1 1
          

Trackback Print

Tags:

Categories:

Location: Blogs Bert Scalzo's Blog