Home, Programming, Oracle Database

SQL Apply Best Practicies: Data Guard in Oracle Database 10g Release 2

claim, and system statistics. See the Oracle Database Performance Tuning Guide [14] Oracle Database 10g Release 2 for more information about Oracle Database Performance Tuning Guide 10g Release 2 ….

More PDF Content

SQL Apply Best Practices: Oracle Data Guard 10g Release 2, Contents:

  • Executive Overview… 4
  • Benefits of SQL Apply… 4
  • Efficient Use of Standby Hardware Resources… 4
  • Reduction in Primary Database Workload… 4
  • Introduction … 5
  • SQL Apply Enhancements … 5
  • Oracle Database 10g Release 1 Enhancements … 5
  • Standby Redo Log Files… 5
  • Real-Time Apply… 5
  • Support for Maximum Protection Mode… 5
  • Zero Downtime Instantiation … 6
  • Improved SQL Apply Performance… 6
  • Faster SQL Apply Switchover and Failover… 6
  • Identification of Unnecessary Log Files … 6
  • Integration with Flashback Database to Resolve Logical Failures… 6
  • Support for More Data Types… 7
  • Ability to Upgrade the Oracle Database Using SQL Apply … 7
  • Improved Redo Data Transmission Security … 7
  • Oracle Database 10g Release 2 Enhancements … 7
  • Improved SQL Apply Performance… 7
  • Support for Fast-Start Failover … 7
  • Enhanced Data Guard Statistics … 7
  • Log Writer Process Asynchronous Transport Enhancements… 7
  • Modified SQL Apply Parameters for Improved Manageability … 8
  • Simpler Logical Standby Configuration with Less Tuning … 8
  • Support for More Data Types… 8
  • SQL Apply Best Practices … 8
  • Confirm Data Type Support … 9
  • Use Standby Redo Log Files … 10
  • Use Real-Time Apply … 10
  • Consider Using a No Data Loss Protection Mode… 10
  • Tune SQL Apply… 11
  • Adjust How Transactions Are Applied on the Logical Standby
  • Database … 11
  • Use the Standard Oracle Tuning Methodology … 13
  • Additional Tuning Guidelines Specific to Logical Standby
  • Databases… 14
  • Benefit From Improved SQL Apply Performance… 14
  • Performance Improvement: Increasing MAX_SERVERS… 16
  • Performance Improvement: Changing COMMIT_ORDER… 16
  • Implement Faster SQL Apply Switchover and Failover… 17
  • Flash Recovery Area and Standby Archived Log Files … 17
  • Manage Logical Standby Archived Log Files … 18
  • Use Fast-Start Failover… 18
  • Use Enhanced Data Guard Management Statistics… 19
  • Use the Asynchronous Redo Transport Enhancements… 19
  • Conclusion… 20
  • Appendix A … 21
  • Quick Reference – Upgrading from Oracle9i Database to Oracle
  • Database 10g… 21
  • References … 21

 

Download SQL Apply Best Practicies: Data Guard in Oracle Database 10g Release 2 pdf from www.oracle.com, 23 pages, 271.66KB.
Related Books

Notice that all download files are from the original source directly. This Pdf file is not located on our server, we also not upload the file on the media sharing like rapidshare, mediafire, megaupload, depositfiles, 4shared etc., nor with torrent technology. This entry was posted under Oracle Database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

This PDF Referals: data guard sql apply, data guard tutorial failover, oracle data guard tutorial, how to tune sql apply performance on 10g oracle dg, oracle 10g data guard pdf

Related Pages: oracle report builder ebook, oracle reports tutorial, Oracle Application Framework tutorial, oracle application framework, bpel tutorial oracle

Leave a Reply

«
»