Monitoring Your Database Cloud Service

Overview

    Purpose

    This tutorial covers how to monitor your Database Cloud Service in the Oracle Cloud.

    Time to Complete

    Approximately 30 minutes

    Introduction

    Oracle Cloud provides two windows for monitoring and operating services:

    • My Services - Monitor and operate all activated services within a single identity domain in My Services.

    • My Account - Monitor the status of all services for an entire account, across all data centers and identity domains in My Services. Active, expired, and pending services are displayed in My Account.

    In this tutorial, you perform the steps to monitor your account and database cloud services.

    Prerequisites

    Before starting this tutorial, you should have performed the Signing Up for a Database Cloud Service tutorial.

Signing in to Your Cloud Account

    You will first sign in to your Oracle Cloud Account. Perform the following steps:

    Open a browser and enter the following URL:

    http://cloud.oracle.com

    Click Sign In.

    myhomepage01

    You want to see all the services for your account. Click the Sign In to My Account button.

    login02

    Enter your Oracle.com credentials and click Sign In.

    login2a

    My Account opens at the Dashboard tab. The Dashboard lists all of the trial or paid services in your account, active or pending activation.

    click My Account


    In addition to the Dashboard tab, the Applications tab lets you examine any available applications, the Platform Services tab lets you examine the platform service in your account, the Orders tab lets you examine any pending orders or buy additional cloud services, and the Security tab lets you examine your current account administrator(s) and add additional account administrators.
     
    account02

Reviewing a Service

    In this section, you review a particular service that your account has access to; in this example, a Database Cloud Service. Perform the following steps:

    In the Dashboard tab, click a service name from the list.

    account08

    A detailed page of information about the service appears, containing 2 tiles: Overview and Metrics. The page opens in the Overview tile. Here you see overview information about the service, including month or year views of the service's status (which days the service has been up, indications of any service incidents). Below that are charts of average storage percent and average object count.

    service01

    Scroll down the Overview tile, and you will see much more information about the service in the Additional Information section.

    additional information

    Click the Metrics tile. This section displays historical usage information on a variety of storage and object metrics.

    service02

    Your are ready to leave the My Account application and access the My Services application. From the drop-down menu next to your username (email address) in the upper right corner, click My Services.

    service02a

    Click Sign In To My Services.

    service02b

    Log in with your Service Credentials and click Sign In.

    myservices03

    The My Services application opens at the Dashboard tab. There is also an Applications tab to examine any applications available in this cloud service, a Platform Services tab that lists all of the services in your identity domain, a Security tab to manage users of this service, and a Notifications tab to examine system-wide and service-level notifications.

    service03a

    To examine detailed information about your database service, click the database name.

    service03b

    The Dashboard changes to show 5 tiles running vertically along the left: Overview, Administration, Exports, Metrics, and Associations. The Overview tile shows information similar to the overview tile that we saw in the My Accounts application.

    service03c

    Scroll to the bottom of the Overview tile, and you will see an Additional Information section similar to what you saw in My Accounts. However, instead of a My Services URL, this section has a Service Instance URL link.  By hovering your mouse over the link, you can see the full path of the URL. This is the URL you will want to provide to the end users for accessing the Database Cloud Service.

    additional information My Services

    Click the Administration tile. Here you can archive applications and lock users from accessing a service. Application archiving will create a backup of your application any time it changes.

    Keep the following in mind when enabling application archiving:

    • The archive is stored in your database tables within your schema which will be counted against your tablespace quota.
    • By default, 5 versions are kept.
    • Archives are created based on changes in the application.
    • Each night a check is made to see if there are application changes, if so, an archive is created. If no change was made, then an archive is not created.
    • If there are already 5 versions and an archive is to be created, the oldest version will be deleted and the new one will be created.


    Administration tab

    Click the Exports tile. From the Exports tab, you can create a data pump export of your data and data structures.

    Exports tab

    Click the Metrics tile. This tab displays storage and object usage metrics of latest and historical timeframes.

    The service utilization data helps you determine whether the service resource allocations are under or over utilized. If a service is under utilized, you may want to evaluate and consider deployment of additional applications or increase http traffic from end users to this service. If it is over utilized, you may want to consider adding additional services and also consider clustering to improve load management.

    The latest usage displays a snapshot of the last set of metrics collected and when those metrics were collected. The history displays usage metrics per day for the last seven days.

    Metrics tab

    There is also an Associations tile to track whether you have associated other Oracle Cloud Services with this service. In this example, the tile indicates that no associations have yet been created.

    Associations tab

Summary

    In this tutorial, you have learned how to:

    • Review your account
    • Review a service
    • Monitor your Database Cloud Service

    Resources

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

Hiding Header Buttons:
Click the Title to hide the buttons in the header. To show the buttons again, simply click the Title again.
Topic List Button:
A list of all the topics. Click one of the topics to navigate to that section.
Expand/Collapse All Topics:
To show/hide all the detail for all the sections. By default, all topics are collapsed
Show/Hide All Images:
To show/hide all the screenshots. By default, all images are displayed.
Print:
To print the content. The content currently displayed or hidden will be printed.

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