Oracle Database Administration
A decent enough DBA should be able to tell you this information off of the top of their head, but sometimes it’s useful to see on average how fast a tablespace has been growing. If you’re licensed to use the AWR views, you can query DBA_HIST_TABLESPACE and DBA_HIST_TBSPC_SPACE_USAGE to trend tablespace growth over time. I
Read MoreDisclaimer: You must be licensed for Active Data Guard, an additional license on top of Enterprise Edition to be able to follow the steps in this guide without violating your license terms. You may be tasked with tuning a query that only runs against your 19c Active Data Guard (ADG) standby database. If you try
Read MoreInstalling Oracle Database is a time-consuming process, especially when done manually. There are plenty of resources on the web for accomplishing the process using Vagrant, Ansible, or other automated build tools. These are helpful and tend to work well, but in some cases, we’re not allowed to make use of this tooling. Having to install
Read MoreAs anyone who has ever had the pleasure of installing Oracle Database has come to know, this process can be quite cumbersome and less than straightforward for someone new to working with Oracle technologies. I could even see how the wise ole’ gray beards may struggle with this if it’s been some time between installations.
Read MoreUse of a recovery catalog provides for additional protection against data loss. The catalog database holds information about databases, their structure, backupsets, and a host of other useful information. The best part about it is that all of this useful information for multiple databases is available in the tables and views of the user that
Read MoreFor most organizations using Oracle Database the de facto tool for monitoring instance health is Oracle Enterprise Manager Cloud Control. While Cloud Control is great at what it does, there are times when the Oracle Management Server (OMS), the Oracle Management Agent, or other components of Cloud Control are down. This could be during maintenance
Read More