PurposeThis 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.
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.
PrerequisitesBefore 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/
In the first case, create an SSH tunnel to port 443 on the instance's VM or load an existing session.
- Expand SSH, then Tunnels.
Enter 443 in the Source port and the IP Address of the
VM concatenated with :443 . Then
- Back to Session, click Save.
- 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.
- A new page is opened in the browser with the URL
you for a user name and password. Enter dbaas_monitor as the
user name and the password specified when the DBaaS instance was
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
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Select a row in this table to see more detailed data
- Back to the Monitor page, view the Wait Events
In this case, the wait events are essentially those of user I/O and CPU consumption.
Access the Configure Page or Configure Section
- Click the Configure tab at the top of the page and
select RDBMS, or RDBMS in the Configure section of the
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.
- Drill down the Parameter Settings in the Configure
The full list of instance parameters appears.
- 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.
You can monitor the DBaaS database with the Oracle Cloud Database
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
- For more detailed information about connecting to Oracle Database instances in the Oracle Database Cloud Service (DBaaS), see the documentation.
- To learn more about Oracle Database Cloud Service, visit the Database Cloud Service.
- For training on the Oracle Cloud platform-as-a-service (PaaS) Services, visit the Oracle Learning Library
- Look at these videos on working with the Oracle Database Cloud Service:
- Lead Curriculum Developer: Dominique Jeunot
- Other Contributors: James Spiller
CreditsPut credits here
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.
- 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.