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 

5 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
  4. enjoying your post. Thanks for the information. Great websites! You made some good points there. I did a search on the topic and found most people will agree with your blog. Such a useful blog for me. Really awesome. I am looking forward for it. I will be very grateful to you if you keep updating your blog. Dumpscollection//AZ-304//350-701

    ReplyDelete
  5. 100% Pass Guarantee is offered by us after WSO2 Certified Enterprise Integrator 6 Developer Exam Enterprise-Integrator-6-Developer exam preparation, with Prepare4Test’s exam dumps. You can pass the Enterprise-Integrator-6-Developer exam in the first go with good marks, and it will be easy for you to attempt all Enterprise-Integrator-6-Developer questions.

    ReplyDelete