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 

3 comments:

  1. Expand your knowledge and gain an edge in the IT marketplace with an Oracle Certification.Oracle offers more than 200 certifications in the areas of applications, cloud, database, operating systems, enterprise management etc.

    ReplyDelete
  2. SQLite is a well known social database https://www.dbdesigner.net the board framework exorbitantly utilized in nowadays.

    ReplyDelete
  3. Try not to try and attempt to experience the shutdown methodology, simply pull the attachment from the divider. recover deleted data from hard drive

    ReplyDelete