Oracle databases have thousands of features that are commonly used by DBAs who need to know the ins and outs of each of these features. Unfortunately, as common as these features are, DBAs often just know enough about these features to “get the job done”.
But as this ebook proves, having an in-depth understanding of the common Oracle features is crucial. Not only will it help you make sure that your database is running smoothly and performs at its best but it will also allow you to get the most out of what Oracle has to offer.
This ebook deep dives into the common Oracle database features to give you the key information you need.
The following topics will be covered:
- Overview of Oracle Sequences
- Sequences and Replication
- Waiting is not what you want... avoid the ITLs
- How is the View?
- MATERIALIZED VIEWS
- CASCADE CONSTRAINTS
- Triggers and Replication
- Redo Logs
- Archive Logs
- Importance of Redo and Archive Logs with Replication