Saturday, March 2, 2019

Monitoring Performance of your Autonomous Data Warehouse (ADW) in Oracle Cloud Infrastructure (OCI)

Monitoring performance of your Autonomous Data Warehouse (ADW) in Oracle Cloud Infrastructure (OCI) 

Introduction

Managing and Monitoring Performance of Autonomous Data Warehouse (ADW) through Service Console in Oracle 
Cloud Infrastructure (OCI). Using the Overview and Activity tabs to get real-time and historical information 
about the utilization of the service and we will scale up your Oracle Autonomous Data Warehouse (ADW) service to 
have more CPUs.

Login to Oracle Cloud and click on Autonomous Data Warehouse (ADW)



Click right side panel using the option ‘Service Console’



Another way to use option 'Service Console'



In Service Console, We have three options

a. Overview
b. Activity
c. Administration



In Overview Option, We can see how much Storage Used (It indicates what percentage of the space is currently in-use), 
How many CPUs allocated for your ADW database and utilization of those CPUs, Running SQL Statements and Average SQL Statement 
Response time (This chart shows the average response time of SQL statements historically).

In Activity Tab, We have two options

a. Monitor
In this tab, we can view real time database activity, CPU utilization, Running SQL Statements and Queued Statements. 
We can look SQL Statements in Real Time as well as Time Period





b. Monitored SQL
In this tab, we can view the status of SQL Statements with Start Time and End Time including complete text of 
SQL Statements. The Monitored SQL tab shows information about current and past monitored SQL statements.



In Administration Tab, We have the following options



If you want to connect the Autonomous Database Warehouse using SQL Developer, we need to intput password and for 
secure connection it will download the credential wallet in zip format automatically to your local file system.



We have one more good option to look in Administration Tab. We can send feedback to Oracle Community 
(Send Feedback to Oracle)



Connecting to ADW  (OrclDB) using SQL Developer

Connection type should be "Cloud Wallet" and for Configuration File option we need to point the downloaded 
credential wallet (Wallet_OrclDB.zip)





Scaling and Performance in ADW

We can use the option "Scale UP/Down" for CPU Count and Storage.



CPU Count increasing from 4 to 8 





Note: We can see "Scaling in Progress" from the above figure.




In same way, we can increase the Storage also dynamically.