Oracle Stack Monitoring just got better with Multitenant Container Database and Pluggable Database monitoring

July 21, 2022 | 5 minute read
Aaron Rimel
Principal Product Manager, Observability and Management
Text Size 100%:

Oracle Cloud Observability and Management Stack Monitoring just got better with the addition of Oracle Multitenant support. Stack Monitoring is an OCI cloud-native monitoring solution and is a new choice now available to monitor Oracle Multitenant Container Databases (CDBs) and Pluggable Databases (PDBs).  Building on the initial release, Stack Monitoring supports discovery and monitoring of applications such as E-Business Suite (EBS) and its underlying application stack components such as Oracle Database and WebLogic Servers.  The support for Oracle Multitenant further enhances this support. Stack Monitoring can discover and monitor Oracle Multitenant Databases running on on-premises hosts or on your OCI Compute instances.

Monitoring Oracle Multitenant CDBs and PDBs feature overview

Stack Monitoring’s UI enables quick and easy discovery of CDB and PDB databases.  The discovery interface is made simple with fill-in-the-blanks fields.  'Discovery' is the onboarding of the CDB into the Stack Monitoring appilcation (discover the CDB, then discover the PDBs).  The discovery automatically associates the CDB with all of the member PDBs.

The CDB homepage provides a plethora of information to help proactively monitor CDBs.  The metrics provided within the CDB homepage give the necessary information to triage database issues.  Easily review metrics such as Database Time, Current Logons, Logical Block Reads, and IO Throughput.  Viewing historical data is easy, simply select the dropdown and choose a time period up to 14 days, or use a custom time period to review data up to 90 days.  The time picker can help  quickly drill into a point in time.

 

Graphical user interfaceDescription automatically generated
Figure 1:  Monitor CDB key performance from its homepage

The CDB homepage includes a summary of alarms for the CDB and all relating PDBs.  Any alarms relating to a PDB will be displayed on the CDB homepage.  The Related Resource Status pie chart provides an availability summary of all related PDBs running within the CDB.  Use the Members page to view the availability status of all of the PDBs in the CDB, as well as easily navigate to any PDB homepage.  

 

Graphical user interface, websiteDescription automatically generated
Figure 2:  Use the Members page to see all discovered PDBs running within the CDB

Clicking a PDB name from the Members page will navigate to the PDB homepage.  From this homepage, you can monitor the PDB health.  The PDB homepage provides a quick access to critical health information about the PDB.  Quickly view the database CPU time or gain visibility into the tablespace utilization.  Similar to the CDB homepage, historical performance can easily be reviewed by selecting the dropdown, or by sliding the time picker.  Sliding the time picker pinpoints a specific time period for investigation.

 

Caption
Figure 3:  Monitor key performance metrics for a specific PDB from its homepage

Proactive monitoring and alarms of Oracle Databases

Use Stack Monitoring to monitor all your Oracle Databases.  Reduce downtimes and shorten incidents with database alarms to notify if the database is experiencing problems.  Setup alarm notifications to send emails or post a message to Slack.  In this example, a notification was sent when a PDB tablespace utilization was greater than 80%.