Oracle Database Exadata Cloud Service: A Beginner's Guide
1st Edition
Published on 9. November 2018
434 pages
978-1-260-12088-2 (ISBN)
Available for download
Description
Quickly Get Up and Running on Oracle Database Exadata Cloud ServiceQuickly 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 ServiceTAG:For a complete list of Oracle Press titles, visit www.OraclePressBooks.com.
More details
Other editions
Additional editions
Brian Spendolini
Oracle Database Exadata Cloud Service: A Beginner's Guide
Book
11/2018
McGraw-Hill Education
€51.50
Shipment within 10-20 days
Content
- Cover
- Title Page
- Copyright Page
- Dedication
- About the Author
- Contents at a Glance
- Contents
- Introduction
- Acknowledgments
- 1 The Oracle Database Exadata Cloud Service
- What Have We Here?
- Exadata in the Cloud
- A Tale of Two Data Centers
- Exadata Cloud Service Shapes
- X5 Exadata Cloud Service
- X6 Exadata Cloud Service
- X7 Exadata Cloud Service
- Virtualized?
- Database Options
- Exadata in a Cloud Environment
- Summary
- 2 Creating an Oracle Database Exadata Cloud Service
- On-Premises Exadata Database Machine Setup
- On-Premises Physical Setup
- Setting Up the Software
- Securing the Platform
- Creating the Exadata Cloud Service
- Creating the Exadata Cloud Service in OCI-C
- Creating the Exadata Cloud Service in OCI
- Summary
- 3 The Exadata Cloud Service UI
- The ExaCS UI in Oracle Cloud Infrastructure Classic
- Modifying the ExaCS
- Deploying Database Features on the ExaCS
- The ExaCS UI in OCI
- The Service Details Page
- Summary
- 4 Exadata Cloud Services Tooling and CLIs
- Setting Up Your Local Environment
- The Exadata Cloud Service REST Services
- REST Services in OCI-C
- REST Services in OCI
- Configure the OCI CLI
- Using the OCI CLI
- The Exadata Cloud Service CLIs
- Connecting to Your Exadata Cloud Service
- Using dbaasapi Tooling
- Using dbaascli Tooling
- Patching a Database Using exadbcpatchmulti
- The Database Backup CLI
- Working with Backups Using the bkup CLI
- Database Recovery Using the bkup CLI
- Summary
- 5 Smart Scans and Storage Indexes
- The Exadata Database Machine Architecture
- Hardware Components
- Software Components
- Query Offloading
- Using Smart Scans with an Exadata Cloud Service
- Setting Up Your Environment
- Using Smart Scans
- Storage Indexes
- Summary
- 6 Compression Techniques
- Data Blocks, Extents, and Segments
- Data Blocks
- Extents
- Segments
- Oracle Advanced Row Compression
- Using Advanced Row Compression
- Hybrid Columnar Compression Overview
- Using Hybrid Columnar Compression
- Warehouse Compression
- Archive Compression
- Examples of HCC Use
- HCC Performance
- DBMS_COMPRESSION
- Compression Tips
- Summary
- 7 Exadata Resource Management
- I/O Resource Manager
- Configuring IORM in ExaCS
- Database Resource Manager
- Resource Consumer Groups
- Resource Plan Directives
- Resource Plans
- Putting It All Together
- Database Resource Manager and Multitenancy
- Configuring DBRM in the Exadata Cloud Service
- Prerequisites for Using Resource Manager with a CDB
- Creating a CDB Resource Plan
- Seeing DBRM in Action
- Intra-Database Resource Manager
- Changing Plans Using DBMS_SCHEDULER
- Instance Caging
- Summary
- 8 Exadata Smart Flash Cache
- The Rise of Flash
- Exadata and Flash
- Exadata Smart Flash Cache
- When the Flash Cache Is Used
- WriteThrough and WriteBack
- Exadata Smart Flash Logging
- Creating the Flash Cache and Flash Grid Disks
- Columnar Flash Caching and Storage Server In-Memory Cache
- The CELL_FLASH_CACHE Storage Clause
- Summary
- 9 Managing and Monitoring the Exadata Cloud Service
- 11g Database Control and Enterprise Manager Express
- Database Control
- Enterprise Manager Express
- SQL Developer
- Connecting to an Exadata Cloud Service with SQL Developer
- Managing the Database with the DBA Panel
- Enterprise Manager Cloud Control 13cR2
- Configure the Hybrid Gateway
- ExaCLI
- Using ExaCLI
- ExaCLI Examples
- Summary
- 10 Migrating to the Exadata Cloud Service
- TDE Location
- Data Pump
- Schema Export and Import
- Full Transportable Export and Import
- RMAN
- Creating a Stage Directory
- Recovering the Database
- Transportable Tablespaces
- Moving a Single Tablespace
- Cross-Platform Transportable Tablespaces Using Backup Sets
- Pluggable Databases
- PDB Unplug/Plug in
- Non-CDB to a PDB
- Remote Clone a PDB or Non-CDB
- Remote Clone a PDB
- TDE, 18c, and PDBs
- Isolated Mode
- Summary
- Index
