Oracle Cloud Database Navigation Notes

Database Navigation in Oracle Cloud

Introduction

  • Oracle's Cloud provides an intuitive interface for database navigation.

  • The user logs into the database actions portal specifically designed for the autonomous database.

Logging In

  • The first step involves logging in as the admin user, which functions as the Database Administrator (DBA) for the autonomous Pluggable Database (PDB).

Database Actions Launch Pad

  • After logging in, the user is directed to the database actions launch pad web page.

  • This page provides functionalities similar to Oracle SQL Developer, including:

    • Running SQL queries

    • Creating charts from SQL statements

    • Modifying database users

    • Additional functionalities available as required.

SQL Query Execution

  • The most commonly used feature by the speaker is SQL execution.

  • The interface resembles Oracle SQL Developer.

  • Users can:

    • Run ad hoc SQL queries

    • Open SQL files and execute their statements

Opening SQL Files

  • The user navigates to the files tab to open local SQL files.

  • The steps to open a file include:

    • Right-clicking on the file (e.g., "registry view")

    • Selecting to open it in a worksheet.

  • Clicking "Run Statement" executes the SQL, showing the latest matches on the PDB.

DDL Queries

  • The second file opened by the user is named "setup DDL".

    • This file contains the Data Definition Language (DDL) for the Star Schema benchmark schema objects pre-installed on Oracle's Autonomous Database.

  • Since these objects already exist, the user runs a simple SELECT statement against one of the tables.

  • Example statement:

    • The user selects the relevant SQL statement, highlights it, and executes it by clicking "Run Statement".

    • The contents of the table are displayed below.

Navigating Database Schemas

  • Returning to the navigator menu, the user can explore various schemas in the database.

  • The user scrolls down to the SSB schema and accesses:

    • A list of all tables in the SSB schema.

Detailed Table Exploration

  • The user expands the "line order" table to view its columns.

  • To view the full DDL for this table, the user:

    • Right-clicks on it, selects "Quick DDL", and saves it to a worksheet.

    • The DDL for the specified table is displayed in the worksheet shortly after.

Database Users

  • The user navigates to the Database Users menu to review existing users.

  • The user can also create new database users, demonstrated by the following steps:

    • Assigning a user name (e.g., "LinkedIn")

    • Specifying a strong password

    • Granting permissions such as creating graphs

    • Allowing database access via the web

    • Setting a quota of one gigabyte on the tablespace.

  • After creating the user, it appears in the list of users.

  • The user can delete this created user by selecting the drop-down list and choosing to delete.

    • After clearing the search box, the list of other users becomes visible.

Performance Hub

  • The user explores the Performance Hub to review recent activity in the database.

    • Observations reveal minimal activity since the user is the only one accessing the database.

Conclusion

  • The cloud-based interface eliminates the need for a database client installed on the workstation, as access and application development can be performed entirely via a web browser.

  • The user concludes their session by navigating back to the database actions page and selecting the sign-out option from the dropdown menu in the upper right corner.