Oracle Database Exadata Cloud Service: A Beginner's Guide

Oracle Database Exadata Cloud Service: A Beginner's Guide

by Brian Spendolini
Released November 2018
Publisher(s): McGraw-Hill
ISBN: 9781260120882

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Quickly Get Up and Running on Oracle Database Exadata Cloud Service

Quickly install, configure, and start using Oracle Database Exadata Cloud Service with the hands-on information contained in this comprehensive Oracle Press guide. Designed for easy learning, the book features real-world examples, detailed illustrations, and step-by-step instructions. Oracle Database Exadata Cloud Service: A Beginner’s Guide walks you through the basics and shows you how to provision, create, and deploy databases.

Basic system administration tasks, including data backup and recovery, software patching, and system updating, are clearly explained. Advanced monitoring and data compression techniques are also covered.

Inside, you’ll discover how to:

•Set up and configure Oracle Database Exadata Cloud Service
•Navigate the user interface
•Work with tooling and CLIs
•Deploy smart scans and storage indexes
•Employ the latest compression techniques
•Handle Oracle Exadata resource management
•Administer Oracle Exadata Smart Flash Cache
•Manage and monitor your Oracle Exadata Cloud Service
•Migrate to Oracle Exadata Cloud Service

TAG:

For a complete list of Oracle Press titles, visit www.OraclePressBooks.com.

Table of contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Dedication
  5. About the Author
  6. Contents at a Glance
  7. Contents
  8. Introduction
  9. Acknowledgments
  10. 1 The Oracle Database Exadata Cloud Service
    1. What Have We Here?
      1. Exadata in the Cloud
    2. A Tale of Two Data Centers
    3. Exadata Cloud Service Shapes
      1. X5 Exadata Cloud Service
      2. X6 Exadata Cloud Service
      3. X7 Exadata Cloud Service
      4. Virtualized?
    4. Database Options
    5. Exadata in a Cloud Environment
    6. Summary
  11. 2 Creating an Oracle Database Exadata Cloud Service
    1. On-Premises Exadata Database Machine Setup
      1. On-Premises Physical Setup
      2. Setting Up the Software
      3. Securing the Platform
    2. Creating the Exadata Cloud Service
      1. Creating the Exadata Cloud Service in OCI-C
      2. Creating the Exadata Cloud Service in OCI
    3. Summary
  12. 3 The Exadata Cloud Service UI
    1. The ExaCS UI in Oracle Cloud Infrastructure Classic
      1. Modifying the ExaCS
      2. Deploying Database Features on the ExaCS
    2. The ExaCS UI in OCI
      1. The Service Details Page
    3. Summary
  13. 4 Exadata Cloud Services Tooling and CLIs
    1. Setting Up Your Local Environment
    2. The Exadata Cloud Service REST Services
      1. REST Services in OCI-C
      2. REST Services in OCI
      3. Configure the OCI CLI
      4. Using the OCI CLI
    3. The Exadata Cloud Service CLIs
      1. Connecting to Your Exadata Cloud Service
      2. Using dbaasapi Tooling
      3. Using dbaascli Tooling
      4. Patching a Database Using exadbcpatchmulti
    4. The Database Backup CLI
      1. Working with Backups Using the bkup CLI
      2. Database Recovery Using the bkup CLI
    5. Summary
  14. 5 Smart Scans and Storage Indexes
    1. The Exadata Database Machine Architecture
      1. Hardware Components
      2. Software Components
    2. Query Offloading
    3. Using Smart Scans with an Exadata Cloud Service
      1. Setting Up Your Environment
    4. Using Smart Scans
    5. Storage Indexes
    6. Summary
  15. 6 Compression Techniques
    1. Data Blocks, Extents, and Segments
      1. Data Blocks
      2. Extents
      3. Segments
    2. Oracle Advanced Row Compression
      1. Using Advanced Row Compression
    3. Hybrid Columnar Compression Overview
    4. Using Hybrid Columnar Compression
      1. Warehouse Compression
      2. Archive Compression
      3. Examples of HCC Use
      4. HCC Performance
    5. DBMS_COMPRESSION
    6. Compression Tips
    7. Summary
  16. 7 Exadata Resource Management
    1. I/O Resource Manager
      1. Configuring IORM in ExaCS
    2. Database Resource Manager
      1. Resource Consumer Groups
      2. Resource Plan Directives
      3. Resource Plans
      4. Putting It All Together
    3. Database Resource Manager and Multitenancy
    4. Configuring DBRM in the Exadata Cloud Service
      1. Prerequisites for Using Resource Manager with a CDB
      2. Creating a CDB Resource Plan
      3. Seeing DBRM in Action
      4. Intra-Database Resource Manager
      5. Changing Plans Using DBMS_SCHEDULER
    5. Instance Caging
    6. Summary
  17. 8 Exadata Smart Flash Cache
    1. The Rise of Flash
      1. Exadata and Flash
    2. Exadata Smart Flash Cache
      1. When the Flash Cache Is Used
      2. WriteThrough and WriteBack
      3. Exadata Smart Flash Logging
      4. Creating the Flash Cache and Flash Grid Disks
      5. Columnar Flash Caching and Storage Server In-Memory Cache
      6. The CELL_FLASH_CACHE Storage Clause
    3. Summary
  18. 9 Managing and Monitoring the Exadata Cloud Service
    1. 11g Database Control and Enterprise Manager Express
      1. Database Control
      2. Enterprise Manager Express
    2. SQL Developer
      1. Connecting to an Exadata Cloud Service with SQL Developer
      2. Managing the Database with the DBA Panel
    3. Enterprise Manager Cloud Control 13cR2
      1. Configure the Hybrid Gateway
    4. ExaCLI
      1. Using ExaCLI
      2. ExaCLI Examples
    5. Summary
  19. 10 Migrating to the Exadata Cloud Service
    1. TDE Location
    2. Data Pump
      1. Schema Export and Import
      2. Full Transportable Export and Import
    3. RMAN
      1. Creating a Stage Directory
      2. Recovering the Database
    4. Transportable Tablespaces
      1. Moving a Single Tablespace
      2. Cross-Platform Transportable Tablespaces Using Backup Sets
    5. Pluggable Databases
      1. PDB Unplug/Plug in
      2. Non-CDB to a PDB
      3. Remote Clone a PDB or Non-CDB
      4. Remote Clone a PDB
    6. TDE, 18c, and PDBs
      1. Isolated Mode
    7. Summary
  20. Index

Product information

  • Title: Oracle Database Exadata Cloud Service: A Beginner's Guide
  • Author(s): Brian Spendolini
  • Release date: November 2018
  • Publisher(s): McGraw-Hill
  • ISBN: 9781260120882