Never Tune SQL Again

When using an Oracle database (11g to 19c) to execute SQL code the correct place to tune is in the Oracle instance. While it is advisable to write code to standards in any tool, it is still best to let Oracle decide the optimal path to the data. This kind of tuning cannot be doneRead moreRead more

Fail-over Database

This document describes the process to implement a standby database. It was written to bring the development team up to speed on the method being undertaken to provide database high-availability, and to describe the features and problems associated with such a configuration. The OracleAutomated Standby Database feature provides the ability to create and maintain aRead moreRead more