Step-by-step Oracle Autonomous Database Creation | Explore Database Management Cloud Tools | OCI

Introduction

In this article, I will demonstrate, how to provision an Autonomous Database on Oracle Cloud Infrastructure, ADB Features, Cloud Tools, and technology to manage your Oracle databases.

Overview

Oracle Cloud Infrastructure Autonomous Database is a fully managed and pre-configured database environment with three available workload types:

• Autonomous Transaction Processing - configures the database for a transactional workload, with a bias toward high volumes of random data access.
• Autonomous Data Warehouse - Configures the database for a decision support or data warehouse workload, with a bias toward large data scanning operations.
• Oracle Autonomous JSON - is a cloud document database service that simplifies the development of JSON-centric applications.

You do not need to configure or manage any hardware or install any software. After provisioning, you can scale the number of CPU cores or storage capacity of the database at any time without impacting availability or performance. Autonomous Database takes care of database creation as well as the following maintenance tasks:

• Database Backup
• Database Patching
• Database Upgrade
• Database Tuning

Step 1: Autonomous Database Creation Process

To start the Autonomous Database creation process:

1. Click on the menu on the left side of the main screen, choose Oracle Database, and then "Autonomous Database"

2. Click on "Create Autonomous Database" and you will be redirected to create Autonomous Database.

3. Fill in the necessary fields to create your Autonomous Database as shown below:

• Display Name: Give your bank a name Database name:
• Give your database a name
• Choose a type of workload: select Data Warehouse/Transaction processing based on your needs
• Choose a deployment type: Serverless

• Create administrator credentials: set a password for ADMIN
• Choose network access: Secure access from everywhere

Note: The password must be 12 to 30 characters and contain at least one uppercase letter, one lowercase letter, and one number. The password cannot contain the double quote (") character or the username "admin".*

• Choose License and Oracle Database Edition: Bring Your Own License (BYOL)
• Choose an Oracle Database Edition: Oracle Database Enterprise Edition (EE)
• Enter a contact email: Your email

Now finish the creation by clicking on the "Create Autonomous Database" button

Step 2: Use the native features of Autonomous Database

Most autonomous database operations can be performed using the main top buttons on the screen:

1. Click on the "Database Actions" button and then on "View all database actions". You will be redirected to a new tab.

2. Log in (if necessary) to the database with the ADMIN user and the password you created in step 1

3. Select the "Catalog" option

4. From the left filter you can chose whatever schema and tables you want to see. For example:

5. Explore the visualization, lineage, impact and statistics fields. When you are finished exploring, click the Close button.

6. Click on the Oracle logo at the top of the page to return to the main screen.

Step 3: Scaling ECPUs and Monitoring SQL Statements

1. On the main screen, click Development Tab then click SQL from the left pane.

Click the "X" to close the Warning and the "X" again to close the "Data Load" window.

Execute queries and scripts, and create objects in the database through the SQL Worksheet

2. Select the SH schema, copy the command below and paste it into the SQL Worksheet and then click the 'Run Script' button. You can easily download the result as well.

select * from sh.sales;        

3. Return to the 'Autonomous Database Details' screen and click the Manage resource allocation button.

4. Increase to 4 ECPUs and click Apply button

5. After confirming the scale, ADW in the console will show the phrase "SCALING IN PROGRESS" and the bank will remain online.

Note: You can go back to the SQL terminal and run the same query again. As I told you, In ADB you can scale CPU's even if the Database workload is going on.

6. Return to the main screen by clicking on the Oracle logo at the top of the page and then select PERFORMANCE HUB.

Use the Performance Hub tool to analyze and tune the performance of a selected Autonomous Database. With this tool, you can view real-time and historical performance data. When you view historical data in the Performance Hub, you are viewing statistics collected as part of the hourly snapshots of your database.

7. Select SQL Monitoring and you will see the list of SQL Statements.

8. Click on the SQL ID of the Query you want to explore:

9. Select Monitor

10. From the launch pad you can download the instant client and so many actions.

11. Click on the Administration tab. Here you have DataPump, APEX Workspaces, Manage Database Users and so on.

Thanks for visiting. Subscribe and stay tuned.... :)

Mentions:

Oracle Cloud Computing Oracle Cloud Amazon Web Services (AWS) Microsoft Azure Google Cloud