Oracle Database Best Practice Guidelines

Here we have mentioned some of the Oracle database best practice for standalone as well for RAC database. It will give value add to your setup.


  • Use SPFILE  
  • Use temporary tablespaces 
  • Register all instances with remote listeners 
  • Use Database Resource Manager 
  • Use resumable space allocation 
  • Use Automatic Segment Space Management 
  • Use locally managed tablespaces 
  • Use Automatic Undo Management 
  • Enable block checking 
  • Enable Flashback Database 
  • Enable ARCHIVELOG mode and use a flash recovery area 
  • Use auto-tune checkpointing 
  • Log checkpoints to the alert log 
  • Multiplex production and standby redo logs 
  • Set CONTROL_FILE_RECORD_KEEP_TIME long enough 
  • Create two or more control files