Monitoring DBaaS Databases

Overview

Purpose

This tutorial covers database monitoring in the Oracle Cloud Database Service using the Oracle Cloud DBaaS Monitor (On-instance monitor).

Time to Complete

Approximately 20 minutes.

Introduction

In this tutorial, you learn how to launch the Oracle Cloud DBaaS Monitor from the Oracle Cloud Database Service and then, you will see how to monitor your database pre-created during the Database Cloud Service (DBaaS) instance creation at the Standard service level.

Prerequisites

Before starting this tutorial, you should have performed the Signing Up for a Database Cloud Service, Connecting to a Database Cloud Service (DBaaS) Instance Through an SSH Tunnel and Creating a Database Cloud Service (DBaaS) Instance tutorials.

Accessing the Oracle Cloud Database Monitor

There are two methods to access the Oracle Cloud Database Monitor called on-instance database monitor.

  • When the HTTPS port on the instance's VM is kept blocked as it is by default when the instance is first created to ensure network security, then create an SSH tunnel to port 443 on the instance's VM.
  • When the HTTPS port on the instance's VM has been unblocked, then you can direct your browser to the URL  https://instance-ip-address/dbaas_monitor/
  1. In the first case, create an SSH tunnel to port 443 on the instance's VM or load an existing session.


    Then click Load.

  2. Expand SSH, then Tunnels. Enter 443 in the Source port and the IP Address of the VM concatenated with :443 . Then click Add.



  3. Back to Session, click Save.



  4. From the Oracle Database Cloud service, click the menu icon in the right side beside the instance you want to monitor, and select Open DBaaS Monitor Console. In this case, NFDBA is the instance to be monitored.



    Another way to access the DBaaS Monitor Console is to click the instance name you chose to monitor and then click the menu icon in the top right of the page.



  5.  A new page is opened in the browser with the URL https://instance-ip-address/dbaas_monitor/ prompting you for a user name and password. Enter dbaas_monitor as the user name and the password specified when the DBaaS instance was created.



    Click OK.

Using the Oracle Cloud DBaaS Monitor

    The DBaaS Monitor Console appears and displays generic information about the Oracle database status of the database pre-created during the instance creation, and configured at the Standard service level. The Oracle DBaaS Monitor home page allows you to monitor and configure the database as well.

    • The database uses 2.02 GB of storage.
    • The waits mainly relate to User I/O and System I/O.
    • There are 45 active and 10 inactive sessions in the database. The database allows a maximum of 472 open sessions.
    • The Alerts reports 31 errors in the alert log file.

    Access the Monitor Page or Monitor Section

    1. Click the Monitor tab at the top of the page or RDBMS in the Monitor section of the page.



      The Database Monitor displays four sections.



    2. Drill down the Storage. Wait a few seconds for the result to appear.



      If the database uses 2.02 GB of storage, it is allocated 2.10 GB.

    3. Move your mouse to one of the tablespaces in the ring to get detailed information. Moving the mouse to the outer ring shows the space used by the tablespace.



      Moving the mouse to the outer ring also shows the free space in the tablespace.



      Moving the mouse to the inner ring shows the space allocated to the tablespace.



    4. To get the details about the segments that use space in one of the tablespaces, click the tablespace name on the right of the page.



    5. Back to the Monitor page, view the Alert Log section.



      An interactive report displays the entries in the database's alert log. The alert log is a chronological log of messages and errors and is commonly used to learn whether the background processes have encountered errors. Among the entries in the alert log you will find critical errors, administrative operations, process errors, and other database events.

    6. Back to the Monitor page, view the Sessions section.



      An interactive report displays information about all currently open sessions in the database. The topmost table shows summarized data about each open session.

    7. Select a row in this table to see more detailed data about it.



    8. Back to the Monitor page, view the Wait Events section.



      In this case, the wait events are essentially those of user I/O and CPU consumption.

    Access the Configure Page or Configure Section

    1. Click the Configure tab at the top of the page and select RDBMS, or RDBMS in the Configure section of the page.



      The Database Configure displays two sections: the Configure Database and the Features. The Features section reports information about options enablement status. In the current example, the Oracle Real Application Cluster option is not enabled whereas the Oracle Spatial and Graph option and all others are enabled.



    2. Drill down the Parameter Settings in the Configure Database section.



      The full list of instance parameters appears.

    3. To modify the value of a parameter, select the parameter, enter a new value, and click the button above the table. You will have an oppportunity to review your change before applying it. Changes that are saved to memory will take effect immediately across all sessions, but will be lost upon the next instance shutdown. Changes that are saved to the SPFILE will take effect upon the next instance startup and are persistent.



      Click OK to confirm your update.

Summary

    You can monitor the DBaaS database with the Oracle Cloud Database Monitor.
    In this tutorial, you learned to:
    • Access the Oracle Cloud Database Monitor
    • Use the Oracle Cloud Database Monitor to:
      • Monitor the storage usage of the database
      • Monitor the alerts of the database
      • Monitor the sessions connected to the database
      • Monitor the wait events of the database
      • Monitor the instance parameters of the database
      • Display the options enabled of the database

      Resources

      Credits

      Put credits here
      • Lead Curriculum Developer: Dominique Jeunot
      • Other Contributors: James Spiller

To navigate this Oracle by Example tutorial, note the following:

Topic List:
Click a topic to navigate to that section.
Expand All Topics:
Click the button to show or hide the details for the sections. By default, all topics are collapsed.
Hide All Images:
Click the button to show or hide the screenshots. By default, all images are displayed.
Print:
Click the button to print the content. The content that is currently displayed or hidden is printed.

To navigate to a particular section in this tutorial, select the topic from the list.