Sep 28, 2021 3:00:00 AM by Dan Hotka
Did you know that you can easily monitor your database health via Quest® Toad for Oracle®? The database health check helps ensure database stability across your application needs. Toad for Oracle Pro DB Admin subscription can run 120 different database health checks, and then generate a report across multiple databases with the outcome of the health check and the differences from the prior report. The report can be automated and emailed to others.
The Toad for Oracle Pro DB Admin suite greatly assists with database stability by providing important application and security checks across your databases in the form of an HTML report.
These database health checks include:
We’ll review each of these areas, below. Note that the entire health check category can be selected or individual areas for monitoring can be selected.
Toad for Oracle database health check
Get Toad for Oracle Base Subscription today
Subscription / eStore: buy up to 10 licenses at a time, get auto update, support, announcements/invites to education.
Talk to our professionals: demos, custom solutions, volume discounts.
Not ready to buy? Get Toad for Oracle a 4th way ... try it free for 30 days.
The database health check can be run across multiple databases Click the green “plus sign” circle and select the database connections you wish to monitor.
Database health check covers multiple databases
This report is organized much like the configuration section. The report defaults to being organized by database but can also be organized by reporting item. Items that need attention appear in red.
Database health check report
This is a powerful feature of the Toad database health check. This report shows the differences in the monitored items from the last time the report was run. Also, if you have assigned database stability items to be fixed/adjusted, these items can be monitored here to see if the work has been done, and what was done.
Database health check differences report
Toad can email these reports, and there are options as to the content of the reports and whether they should be sent.
Database health check settings panel
Notice the parameters can be set to only email when there are differences (probably would be my choice) or when more database stability (bad) differences exist. Email notifications are set up using Toad Options --> Editor --> Email.
Email options panel
The database health check can be automated, and scheduled to run at specific times or on specific days. Automating the database health check saves time and ensures regular attention to health items. Selecting the types of reports you receive allows you to only be notified when database stability is at risk.
Database health check via automation designer
The Toad for Oracle DBA Suite can easily monitor your databases for possible issues. This monitoring helps ensure database stability by alerting you to fix issues before they become a problem. Toad allows for the database health check to be automated so it can run daily or weekly, depending on your application needs.
Data sheet: Toad for Oracle DB Admin Module.
Blog and Video Demo: Why an Oracle Ace thinks Toad® has the best SQL editor in the business
Oracle Documentation: Explain Plan Content
Oracle Documentation: Explaining a SQL statement: Basic Steps
Chapter 10 “Toad as a SQL Tuning Tool” in Toad for Oracle Unleashed.
Dan Hotka has several course offerings in and around SQL Performance Tuning using the Toad for Oracle suite.
If you think your colleagues would benefit from this blog, share it now on social media with the buttons located at the top of this blog post. Thanks!
Dan Hotka has several course offerings that use Toad and Toad Data Point.
Written by Dan Hotka
Dan Hotka is an Author/Instructor/Expert/Oracle ACE Director Alumni who uses TOAD regularly in his web-based and on-line courses. He is well published with many books still available on Amazon or www.DanHotka.com. Dan is available for user groups and company educational events. He regularly speaks at user groups around the world. Check his website for course listings, references, and discount codes for his online courses based in Safari.
Dan's most recent book is Toad for Oracle Unleashed