Table of Contents

• Title and Copyright Information
• Preface
• 1 Implementation Overview
  • Schema Architecture
  • Audit and Delete Tracking
  • APEX Workspaces
    • Auxiliary Workspaces
      • Usage and Access Control
  • Privilege Model
    • Developer Access in RDS
    • Database Developer Privileges
    • Restrictive Custom Privilege Models
    • Report Developer Privileges (Oracle Analytics Server)
    • Report Consumer Privileges (Oracle Analytics Server)
    • Oracle Analytics Server Roles
  • Supported Cloud Services
  • Known Limitations and Issues
• 2 Typical Implementation Events
• 3 Customer Responsibilities
  • Performance and Scalability
  • Resource Monitoring
  • Maintenance Preparedness
  • Pre-Maintenance Responsibilities
  • Post-Maintenance Responsibilities
  • Extension Management
  • Communication with Oracle
• 4 Getting Started
  • Step 1: Setting Up the Workspace Administrators
    • Prerequisites
    • Steps
  • Step 2: Setup RDS Database Operations Console Access
    • Prerequisites
    • Steps
  • APEX User Management
• 5 Oracle Analytics Server
  • Determining Your Tenant Name
    • Prerequisites
    • Steps to Identify the Tenant Name
  • Setup Access to OAS
    • Prerequisites
    • Steps to Assign a User to an OAS Group
• 6 Getting Started with Extensions
  • Overview
    • Access to Replicated Data
  • Custom Schemas and Workspaces
    • Primary Custom Schema
    • Auxiliary Custom Schemas (Per Cloud Service)
    • Auxiliary APEX Workspaces (RDS_CUSTOM_1, RDS_CUSTOM_2, RDS_CUSTOM_3)
    • Summary: Schema and Workspace Types
  • Schema Access and Grants
    • Grants to Custom Objects
    • Grants to Replicated Objects
    • Grants to Auxiliary Workspace Schema
    • Summary Table
  • Synonym Management
    • Create Synonyms
    • Drop Synonyms
    • Cleanup Synonyms
  • Tools for Extension
    • Oracle APEX
    • Oracle REST Data Services (ORDS)
    • Object Storage and DBMS_CLOUD
  • Environment Considerations
  • Prerequisites
    • Accessing the APEX UI
• 7 Obtaining ORDS Service Credentials
  • Generating an ORDS Access Token
    • Generating an Access Token Using cURL
    • Generating an Access Token Using POSTMAN
• 8 Accessing Object Store
  • Overview
  • Obtaining a Pre-Authenticated Request (PAR) URL
  • Constructing an Object Storage Object URL
  • Obtaining Object Storage Credentials
• 9 ORDS RESTful Services
  • Overview
  • Implementing a RESTful Service in APEX
  • Invoking a RESTful Service from POSTMAN
• 10 ORDS PRE-HOOK
• 11 Using RDS to Build a Data Producing Service
  • Overview
  • GET Services
  • POST Services
  • Long Responses
• 12 Using RDS to Build a Data Consuming Service
• 13 Exporting Data to Object Storage
  • Prerequisites
  • Exporting Data Using a PAR
  • Exporting Data with a Credential
• 14 Importing Data from Object Storage
  • Prerequisites
  • Importing Data Using a PAR
  • Importing Data Using a Credential
• 15 DBMS Scheduler Jobs
• 16 Retail Home Integrations
  • In Context Launch of an APEX App
  • Launching APEX Apps from Retail Home
• 17 Invoking External Services
• 18 Retail DB Ops Console
  • Home
  • AWR Reports
    • Search Generated AWR Reports
    • Generate AWR Custom Reports
  • Top SQL
  • DBMS Jobs
  • Database Metrics
  • Application Properties
  • Session Management
  • Session Management API
    • Package Overview
    • Procedure and Function Details
      • LIST_RDS_SESSIONS
      • KILL_RDS_SESSION (SID and SERIAL)
      • KILL_RDS_SESSION (AUDSID)
• 19 Sending Email from APEX
• 20 Monitoring Replication Lag
• 21 Notification-Based Monitoring
  • Setting up the Notification Type
  • Implementing a RESTful Service in RDS
  • Setting up the POM Job
• 22 Storage and CPU Usage
• 23 Query Tuning
  • Introduction
  • How SQL Executes - A Conceptual Overview
    • Relational Databases: What You Need to Know
    • A Mental Model You Can Use
    • Where Problems Show Up
    • Start Here: Performance Triage
    • Next Step
  • Baselining Your Query
    • Why Baselining Matters
    • Baseline Tuning
    • What to Capture
    • When to Baseline
    • Baseline Template (Example)
    • Baseline SQL Script (for Recent Performance Snapshot)
      • Output Columns
    • Baselining Procedure
      • Step 1: Create a Tracking Table
      • Step 2: Create the Baselining Procedure
      • Step 3: Example Call
    • Optional: Automate It Nightly for Key Queries
      • Step 1: Create a Tracking Table
      • Step 2: Create a Batch Baselining Procedure
      • Step 3: Optional: Schedule the Job (DBMS_SCHEDULER)
  • Is My Query Slow?
    • Start with your Requirements
    • How to Think About "Fast Enough"
      • Measuring Execution Time
      • Don't Tune Without a Target
    • Diagnosing a Slow Query
      • Step 1: Get the SQL_ID
      • Step 2: Get the Execution Plan
      • Step 3: Ask These Questions
      • Step 4: Check for Waits
        • Current Waits
        • Recent Waits
        • What's a Spill
      • Step 5: Cross Check Stats
        • What's a Skewed Column
          • Why Skew Matters
          • How Oracle Handles Skew
      • Step 6: Consider Plan History
        • Summary: What to do Next
    • Diagnosing System Wide Performance Issues
      • Step 1: Use AWR Reports to Understand System Load
        • What AWR Tells You
        • Focus Areas in the AWR Report
          • Top 10 Foreground Events by Total Wait Time
          • Load Profile
          • SQL Statistics
          • Understanding Temporary Table Space Usage
          • Blocking and Concurrency
        • What to Compare
        • Report Retention Notes
        • When to Escalate or Log a Baseline
        • AWR Review Checklist
      • Step 2: Use Database Metrics (DB Ops Console)
      • Step 3: Triage with "Top SQL"
      • Check DBMS Jobs (If Relevant)
      • Step 5: Session Management (Admin Role)
        • Takeaway
    • Understanding Plan Instability
      • What is Plan Instability?
      • Why Plans Change
      • How to Detect Plan Instability
      • When Plan Changes are Bad
      • What To Do
• 24 Using FTS: An Example
  • Overview
  • Functions and Procedures
    • get_idcs_token
    • generate_par
    • put_object_in_store
    • export_query_to_blob
    • Example Usage
      • Error Handling
  • Securely Obtaining an IDCS Token
    • Overview
    • Security Considerations
    • Using the get_idcs_token_for_planning_app Function
    • Example Usage
  • Using the export_query_to_object_store Procedure
    • Prerequisites
    • Usage
    • Customization
    • Example
  • • get_idcs_token
    • generate_par
    • put_object_in_store
    • export_query_to_blob
• 25 Transferring Table Data
  • Assumptions
  • Step 1: Export Tables from Source ADW
    • Example PL/SQL Block
  • Step 2: Import Tables to Destination ADW
    • Example PL/SQL Block
  • Notes
  • Optional Enhancements
• 26 Version Updates
• 27 Notes
  • APEX
  • APEX and Autonomous Databases
  • Known Limitations and Issues
    • Limits on Service Initiated Queries and PL/SQL Blocks
    • APEX and Progressive Web Apps (PWA)
    • Data Access
    • APEX Roles and Privileges
    • APEX UI Explain Plan
    • Reserved Application ID Range
    • Replication, Refresh, and CSN_NBR
    • OAUTH Token Scope
    • APEX Administration Services
    • SMTP Services
    • Obtaining RDS Outbound IP Address
    • Exporting Query Results in APEX
    • CPU Utilization Reporting