16 Monitoring a DBaaS Cloud

This chapter describes support for monitoring a DBaaS Cloud. It contains the following sections:

16.1 Viewing the Database Pool Home Page

A database pool contains a set of resources that can be used to provision a database instance within a PaaS Infrastructure Zone.

Figure 16-1 Database Pool Home

Database Pool Home Page

This page contains the following regions:

  • General: This region displays the following:

    • Summary: Displays a description of the database pool and PaaS Infrastructure Zone to which it belongs.

    • Members and Databases: Shows the list of Members (Oracle Homes and Hosts) and Databases in the pool. The Databases region lists the total number of databases and the number of single instance or RAC databases in the pool.

    • Placement Policy Constraints: The placement policy constraints that specify maximum ceilings for each host member of the pool are displayed.

  • Standby Pools: If one or more standby pools are present, they are listed here.

  • Top Utilized Hosts: This region shows the list of top utilized hosts over the last 7 days. Click on the link to drill down to the Host Home page. You can sort by:

    • Memory: The average memory utilized over the last 7 days as a percentage of the total memory on the host.

    • CPU: The average CPU utilized over the last 7 days as a percentage of the CPU available on the host.

    • Storage: The average storage utilized over the last 7 days as a percentage of the total storage available on the host.

    • Instances: The number of database instances on the host.

  • Members: Lists all the members in the database pool. Click on the links in the Members table to drill down to the Database or Host Home page.

  • Overview of Incidents and Problems: This region lists any incidents or problems that have occurred.

  • Memory Utilization: The chart shows the memory utilization by different hosts present in the database pool. The color coded chart shows the different memory utilization range across the different hosts.

  • CPU Utilization: The chart shows the CPU utilization by different hosts present in the database pool. The color coded chart shows the different CPU utilization range across the different hosts.

  • Storage Utilization: The chart shows the storage utilization by different hosts present in the database pool. The color coded chart shows the different storage utilization range across the different hosts.

  • Service Template and Instances: Shows the service templates and service instances associated with the database pool.

16.2 Viewing the Schema Pool Home Page

You can define one or more schemas that can be deployed on a database.

Figure 16-2 Schema Pool Home

Schema Pool Home Page
  • General: This region displays the following:

    • Summary: Displays a description of the schema pool and PaaS Infrastructure Zone to which it belongs. I

    • Members and Services: Shows the list of Members (Databases and Hosts) and Services in the pool.

    • Placement Policy Constraints: The placement policy constraints that specify maximum ceilings for each database member in the pool are displayed.

  • Top Allocated Databases: This region shows the list of top utilized databases in the schema pool. Click on the link to drill down to the Database Instance page.

    • Memory: The total memory allocated for each service based on the workload as a percentage of the total SGA size of the database.

    • CPU: The total CPU allocated for each service based on the workload as a percentage of the CPU count.

    • Storage: The total storage utilized on all the tablespaces of the database as a percentage of the total size of the database.

      Note:

      Total here includes requests budgeted for services that have been requested and are active.
    • Services: The number of database services.

  • Members: Lists all the members in the schema pool. Click on the links in the Members table to drill down to the Database Instance Home page.

  • Overview of Incidents and Problems: This region lists any incidents or problems that have occurred.

  • Memory Allocation: The chart shows the memory allocation across different databases present in the schema pool. The color coded chart shows the memory allocation range across all the databases.

  • CPU Allocation: The chart shows the CPU allocation across different databases present in the schema pool. The color coded chart shows the CPU allocation range across all the databases.

  • Storage Allocation: The chart shows the storage allocation across different databases present in the schema pool. The color coded chart shows the storage allocation range across all the databases.

  • Service Template and Instances: Shows the service templates and service instances associated with the schema pool.

16.3 Viewing the Pluggable Database Pool Home Page

A PDB pool contains one or more container databases that can be used to create PDBs within a PaaS Infrastructure Zone.

Figure 16-3 PDB Pool Home Page

Surrounding text describes Figure 16-3 .

This page contains the following regions:

  • General: This region contains the following:

    • Summary: This region displays a description of the database pool and PaaS Infrastructure Zone to which it belongs. Click on the Parent PaaS Infrastructure Zone link to drill to the Home page.

    • Members and Databases: This region displays a list of Members (Oracle Homes and Hosts) and Databases in the pool. The Databases region lists the total number of databases and the number of single instance or RAC databases in the pool.

    • Placement Policy Constraints: The placement policy constraints that specify maximum ceilings for the pool are displayed.

  • Top Allocated Databases: This region shows 5 to 15 pluggable databases (depending on your selection), sorted by Memory, CPU, Storage, or Services.

    • Memory: The total memory allocated for each service based on the workload as a percentage of the total SGA size of the Container database.

    • CPU: The total CPU allocated for each service based on the workload as a percentage of the total CPU count.

    • Services: The number of database services.

  • Members: This region shows the list of members in the PDB pool. Click on the links in the Members table to drill down to the database or host home page.

  • Overview of Incidents and Problems: This region shows a list of any incidents and problems that have occurred for any of the targets in the PDB pool.

  • Memory Allocation: This chart shows the memory allocation by different container databases in the database pool. The color coded chart shows the memory allocation range across all the container databases.

    Note:

    Total here includes requests budgeted for services that have been requested and are active.
  • CPU Allocation: This chart shows the CPU allocation by different container databases in the pool. The color coded chart shows the CPU allocation range across all the container databases.

  • Service Templates and Instances: This region shows the list of service templates associated with the PDB pool. Click on the Service Template link to drill down to the Service Template Details page.