Table of Contents
- Title and Copyright Information
- Preface
-
1
Introducing Oracle Exadata System Software
- 1.1 Overview of Oracle Exadata System Software
-
1.2
Key Features of Oracle Exadata System Software
- 1.2.1 Reliability, Modularity, and Cost-Effectiveness
- 1.2.2 Compatibility with Oracle Database
- 1.2.3 Smart Flash Technology
- 1.2.4 Persistent Memory Accelerator and RDMA
- 1.2.5 Exadata RDMA Memory
- 1.2.6 Centralized Storage
- 1.2.7 I/O Resource Management (IORM)
- 1.2.8 Exadata Hybrid Columnar Compression
- 1.2.9 In-Memory Columnar Format Support
- 1.2.10 Offloading Data Search and Retrieval Processing
- 1.2.11 Offloading of Incremental Backup Processing
- 1.2.12 Fault Isolation with Quarantine
- 1.2.13 Protection Against Data Corruption
- 1.2.14 Fast File Creation
- 1.2.15 Storage Index
- 1.3 Oracle Exadata System Software Components
-
2
Administering Oracle ASM on Exadata
- 2.1 Overview of Oracle Exadata Storage Using Oracle ASM
-
2.2
Administering Oracle ASM on Exadata
- 2.2.1 Configuring Exadata Storage Discovery for Oracle ASM
- 2.2.2 Understanding Oracle ASM Disk Groups for Oracle Exadata Storage Servers
- 2.2.3 Creating Oracle ASM Disk Groups
- 2.2.4 Adding a Disk to an Oracle ASM Disk Group
- 2.2.5 Mounting or Dismounting an Oracle ASM Disk Group
- 2.2.6 Changing a Disk to Offline or Online
- 2.2.7 Dropping a Disk from an Oracle ASM Disk Group
- 2.2.8 Dropping an Oracle ASM Disk Group
- 2.2.9 Enabling the Oracle ASM appliance.mode Attribute
- 2.2.10 Checking Disk Group Balance
- 2.2.11 Setting the Oracle ASM Disk Repair Timer
-
2.3
Administering Oracle Exadata Storage Server Grid Disks with Oracle ASM
- 2.3.1 Naming Conventions for Oracle Exadata Storage Server Grid Disks
- 2.3.2 Changing an Oracle Exadata Storage Server Grid Disk That Belongs to an Oracle ASM Disk Group
- 2.3.3 Resizing Grid Disks
- 2.3.4 Determining Which Oracle ASM Disk Group Contains an Oracle Exadata Storage Server Grid Disk
- 2.3.5 Determining Which Oracle Exadata Storage Server Grid Disks Belong to an Oracle ASM Disk Group
- 2.3.6 Handling Disk Replacement
- 3 Administering Oracle Database on Exadata
-
4
Maintaining Oracle Exadata System Software
- 4.1 Understanding Oracle Exadata System Software Release Numbering
- 4.2 Understanding Automated Storage Server Maintenance Tasks and Policies
- 4.3 Recommendations for Changing the Exadata Storage Server Network Address
- 4.4 Using the ipconf Utility
- 4.5 Oracle Exadata System Software Validation Tests and Utilities
- 4.6 Locating Serial Numbers for System Components
- 4.7 Diagnostic and Repair Utilities
- 4.8 System Diagnostics Data Gathering with sosreports and Oracle ExaWatcher
- 4.9 Host Console Support
- 4.10 Oracle Linux Kernel Crash Core Files
- 4.11 Monitoring syslog Messages Remotely
-
5
Managing I/O Resources
-
5.1
Understanding I/O Resource Management (IORM)
- 5.1.1 About I/O Resource Management (IORM) in Exadata Database Machine
- 5.1.2 About Database Resource Management Within a Database
-
5.1.3
About Interdatabase Resource Management
- 5.1.3.1 About Interdatabase IORM Plan Directives
- 5.1.3.2 Using Interdatabase Plans for Consolidation and Isolation
- 5.1.3.3 Using IORM to Control Database Access to Exadata Cache Resources
- 5.1.3.4 About Flash Cache Management in IORM Plans
- 5.1.3.5 About XRMEM Cache Management in IORM Plans
- 5.1.3.6 About PMEM Cache Management in IORM Plans
- 5.1.3.7 Tips for Managing Interdatabase Resource Plans
- 5.1.4 About Cluster Resource Management
- 5.1.5 About Category Resource Management
- 5.1.6 About Consumer Groups and Resource Plans
- 5.1.7 About CDB Plans and Pluggable Databases
-
5.2
Administering IORM
- 5.2.1 Setting the IORM Objective
-
5.2.2
Administering Database Resource Management
- 5.2.2.1 Setting Up Consumer Groups and Categories
- 5.2.2.2 Assigning Sessions to Consumer Groups
- 5.2.2.3 Creating a CDB Plan
- 5.2.2.4 Creating a Database Plan
- 5.2.2.5 Enabling a Database Resource Plan
- 5.2.2.6 Managing Fast File Creation
- 5.2.2.7 Managing Data Import
- 5.2.2.8 Managing Oracle Recovery Manager Backups and Copies
-
5.2.3
Administering the IORM Plan
- 5.2.3.1 Setting the IORM Plan
- 5.2.3.2 Using Share-Based Resource Management
- 5.2.3.3 Using Allocation-Based Resource Management
- 5.2.3.4 Using the limit Attribute
- 5.2.3.5 Controlling Access to Flash Cache and Flash Log
- 5.2.3.6 Using Flash Cache Attributes
- 5.2.3.7 Controlling Access to XRMEM Resources
- 5.2.3.8 Using XRMEM Cache Attributes
- 5.2.3.9 Controlling Access to PMEM Cache and PMEM Log
- 5.2.3.10 Using PMEM Cache Attributes
- 5.2.3.11 Using the role Attribute
- 5.2.3.12 Using the asmcluster Attribute
- 5.2.3.13 Resetting Default Values in an IORM Plan
- 5.2.4 Listing an I/O Resource Management Plan
- 5.2.5 Managing Flash Cache Quotas for Databases and PDBs
- 5.2.6 Managing XRMEM Cache Quotas for Databases and PDBs
- 5.2.7 Managing PMEM Cache Quotas for Databases and PDBs
- 5.2.8 Using IORM Profiles
- 5.2.9 Verifying the Configuration of I/O Resource Management
-
5.1
Understanding I/O Resource Management (IORM)
-
6
Monitoring Exadata
- 6.1 Introducing Exadata Monitoring Tools and Information Sources
- 6.2 Guidelines for Exadata Monitoring
-
6.3
Monitoring Oracle Exadata System Software
Components
- 6.3.1 Monitoring Exadata Smart Flash Cache
- 6.3.2 Monitoring XRMEM Cache
- 6.3.3 Monitoring PMEM Cache
- 6.3.4 Monitoring Exadata Smart Flash Log
- 6.3.5 Monitoring XRMEM Log
- 6.3.6 Monitoring PMEM Log
-
6.3.7
Monitoring Smart I/O
- 6.3.7.1 Monitoring Smart I/O Using AWR
- 6.3.7.2 Monitoring Smart I/O Using Database Statistics and Wait Events
- 6.3.7.3 Monitoring Smart I/O Using SQL Monitor
- 6.3.7.4 Monitoring Smart I/O Using SQL Explain Plan
- 6.3.7.5 Monitoring Smart I/O Using Exadata Metrics
- 6.3.7.6 What to Look For When Monitoring Smart I/O
- 6.3.8 Monitoring I/O Resource Management (IORM)
- 6.3.9 Monitoring Cell Disk I/O
- 6.3.10 Monitoring Grid Disks
- 6.3.11 Monitoring the Host Interconnect
-
6.4
Using Exadata Monitoring Objects
- 6.4.1 Using Metrics
- 6.4.2 Monitoring Alerts
- 6.4.3 Displaying Active Requests
- 6.4.4 Using Real-Time Insight
-
7
Using the CellCLI Utility
- 7.1 Overview of the CellCLI Utility
- 7.2 About CellCLI Administration Commands
- 7.3 About CellCLI Object Commands
- 7.4 About CellCLI Object Types
- 7.5 About Quoting Object Names
- 7.6 About CellCLI Object Attributes
-
7.7
CellCLI Command Reference
-
7.7.1
ALTER
- 7.7.1.1 ALTER ALERTHISTORY
-
7.7.1.2
ALTER CELL
- 7.7.1.2.1 ALTER CELL Commands for Managing Services
- 7.7.1.2.2 ALTER CELL Commands for Managing Exadata Storage Server Hardware
- 7.7.1.2.3 ALTER CELL Commands for Configuration Validation
-
7.7.1.2.4
ALTER CELL Commands for Setting
Attributes
- 7.7.1.2.4.1 Caching Attributes
- 7.7.1.2.4.2 Alert Notification Attributes
- 7.7.1.2.4.3 Alert Summary Attributes
- 7.7.1.2.4.4 SYSLOG Attributes
- 7.7.1.2.4.5 Disk Scrubbing Attributes
- 7.7.1.2.4.6 Security Certificate Attributes
- 7.7.1.2.4.7 Persistence Attributes
- 7.7.1.2.4.8 Real-Time Insight Attributes
- 7.7.1.2.4.9 Miscellaneous Attributes
- 7.7.1.3 ALTER CELLDISK
- 7.7.1.4 ALTER FLASHCACHE
- 7.7.1.5 ALTER GRIDDISK
- 7.7.1.6 ALTER IBPORT
-
7.7.1.7
ALTER IORMPLAN
- 7.7.1.7.1 Directives for a Category Plan
- 7.7.1.7.2 Directives for a Database Plan
- 7.7.1.7.3 Directives for a Cluster Plan
- 7.7.1.7.4 name Attribute
- 7.7.1.7.5 share Attribute
- 7.7.1.7.6 allocation and level Attributes
- 7.7.1.7.7 limit Attribute
- 7.7.1.7.8 flashcache Attribute
- 7.7.1.7.9 xrmemcache Attribute
- 7.7.1.7.10 pmemcache Attribute
- 7.7.1.7.11 flashlog Attribute
- 7.7.1.7.12 xrmemlog Attribute
- 7.7.1.7.13 pmemlog Attribute
- 7.7.1.7.14 flashcachelimit Attribute
- 7.7.1.7.15 flashcachemin Attribute
- 7.7.1.7.16 flashcachesize Attribute
- 7.7.1.7.17 xrmemcachelimit Attribute
- 7.7.1.7.18 xrmemcachemin Attribute
- 7.7.1.7.19 xrmemcachesize Attribute
- 7.7.1.7.20 pmemcachelimit Attribute
- 7.7.1.7.21 pmemcachemin Attribute
- 7.7.1.7.22 pmemcachesize Attribute
- 7.7.1.7.23 asmcluster Attribute
- 7.7.1.7.24 role Attribute
- 7.7.1.7.25 type Attribute
- 7.7.1.8 ALTER LUN
- 7.7.1.9 ALTER METRICDEFINITION
- 7.7.1.10 ALTER OFFLOADGROUP
- 7.7.1.11 ALTER PHYSICALDISK
- 7.7.1.12 ALTER PMEMCACHE
- 7.7.1.13 ALTER QUARANTINE
- 7.7.1.14 ALTER SOFTWAREUPDATE
- 7.7.1.15 ALTER THRESHOLD
- 7.7.1.16 ALTER USER
- 7.7.1.17 ALTER XRMEMCACHE
- 7.7.2 ASSIGN KEY
- 7.7.3 CALIBRATE
-
7.7.4
CREATE
- 7.7.4.1 CREATE CELL
- 7.7.4.2 CREATE CELLDISK
- 7.7.4.3 CREATE DIAGPACK
- 7.7.4.4 CREATE FLASHCACHE
- 7.7.4.5 CREATE FLASHLOG
- 7.7.4.6 CREATE GRIDDISK
- 7.7.4.7 CREATE KEY
- 7.7.4.8 CREATE PMEMCACHE
- 7.7.4.9 CREATE PMEMLOG
- 7.7.4.10 CREATE QUARANTINE
- 7.7.4.11 CREATE ROLE
- 7.7.4.12 CREATE THRESHOLD
- 7.7.4.13 CREATE USER
- 7.7.4.14 CREATE XRMEMCACHE
- 7.7.4.15 CREATE XRMEMLOG
-
7.7.5
DESCRIBE
- 7.7.5.1 DESCRIBE ACTIVEREQUEST
- 7.7.5.2 DESCRIBE ALERTDEFINITION
- 7.7.5.3 DESCRIBE ALERTHISTORY
- 7.7.5.4 DESCRIBE CELL
- 7.7.5.5 DESCRIBE CELLDISK
- 7.7.5.6 DESCRIBE DATABASE
- 7.7.5.7 DESCRIBE DISKMAP
- 7.7.5.8 DESCRIBE FLASHCACHE
- 7.7.5.9 DESCRIBE FLASHCACHECONTENT
- 7.7.5.10 DESCRIBE FLASHLOG
- 7.7.5.11 DESCRIBE GRIDDISK
- 7.7.5.12 DESCRIBE IBPORT
- 7.7.5.13 DESCRIBE IORMPLAN
- 7.7.5.14 DESCRIBE KEY
- 7.7.5.15 DESCRIBE LUN
- 7.7.5.16 DESCRIBE METRICCURRENT
- 7.7.5.17 DESCRIBE METRICDEFINITION
- 7.7.5.18 DESCRIBE METRICHISTORY
- 7.7.5.19 DESCRIBE OFFLOADGROUP
- 7.7.5.20 DESCRIBE PHYSICALDISK
- 7.7.5.21 DESCRIBE PLUGGABLEDATABASE
- 7.7.5.22 DESCRIBE PMEMCACHE
- 7.7.5.23 DESCRIBE PMEMLOG
- 7.7.5.24 DESCRIBE QUARANTINE
- 7.7.5.25 DESCRIBE ROLE
- 7.7.5.26 DESCRIBE SOFTWAREHISTORY
- 7.7.5.27 DESCRIBE SOFTWAREUPDATE
- 7.7.5.28 DESCRIBE THRESHOLD
- 7.7.5.29 DESCRIBE USER
- 7.7.5.30 DESCRIBE XRMEMCACHE
- 7.7.5.31 DESCRIBE XRMEMCACHECONTENT
- 7.7.5.32 DESCRIBE XRMEMLOG
-
7.7.6
DROP
- 7.7.6.1 DROP ALERTHISTORY
- 7.7.6.2 DROP CELL
- 7.7.6.3 DROP CELLDISK
- 7.7.6.4 DROP FLASHCACHE
- 7.7.6.5 DROP FLASHLOG
- 7.7.6.6 DROP GRIDDISK
- 7.7.6.7 DROP PMEMCACHE
- 7.7.6.8 DROP PMEMLOG
- 7.7.6.9 DROP QUARANTINE
- 7.7.6.10 DROP ROLE
- 7.7.6.11 DROP SOFTWAREHISTORY
- 7.7.6.12 DROP THRESHOLD
- 7.7.6.13 DROP USER
- 7.7.6.14 DROP XRMEMCACHE
- 7.7.6.15 DROP XRMEMLOG
- 7.7.7 EXIT
- 7.7.8 EXPORT CELLDISK
- 7.7.9 GRANT
- 7.7.10 HELP
- 7.7.11 IMPORT CELLDISK
-
7.7.12
LIST
- 7.7.12.1 LIST ACTIVEREQUEST
- 7.7.12.2 LIST ALERTDEFINITION
- 7.7.12.3 LIST ALERTHISTORY
- 7.7.12.4 LIST CELL
- 7.7.12.5 LIST CELLDISK
- 7.7.12.6 LIST DATABASE
- 7.7.12.7 LIST DIAGPACK
- 7.7.12.8 LIST DISKMAP
- 7.7.12.9 LIST FLASHCACHE
- 7.7.12.10 LIST FLASHCACHECONTENT
- 7.7.12.11 LIST FLASHLOG
- 7.7.12.12 LIST GRIDDISK
- 7.7.12.13 LIST IBPORT
- 7.7.12.14 LIST IORMPLAN
- 7.7.12.15 LIST IORMPROFILE
- 7.7.12.16 LIST KEY
- 7.7.12.17 LIST LUN
- 7.7.12.18 LIST METRICCURRENT
- 7.7.12.19 LIST METRICDEFINITION
- 7.7.12.20 LIST METRICHISTORY
- 7.7.12.21 LIST METRICSTREAM
- 7.7.12.22 LIST OFFLOADGROUP
- 7.7.12.23 LIST OFFLOADPACKAGE
- 7.7.12.24 LIST PHYSICALDISK
- 7.7.12.25 LIST PLUGGABLEDATABASE
- 7.7.12.26 LIST PMEMCACHE
- 7.7.12.27 LIST PMEMLOG
- 7.7.12.28 LIST QUARANTINE
- 7.7.12.29 LIST ROLE
- 7.7.12.30 LIST SOFTWAREHISTORY
- 7.7.12.31 LIST SOFTWAREUPDATE
- 7.7.12.32 LIST THRESHOLD
- 7.7.12.33 LIST USER
- 7.7.12.34 LIST XRMEMCACHE
- 7.7.12.35 LIST XRMEMCACHECONTENT
- 7.7.12.36 LIST XRMEMLOG
- 7.7.13 QUIT
- 7.7.14 REVOKE
- 7.7.15 SET
- 7.7.16 SPOOL
- 7.7.17 START and @
-
7.7.1
ALTER
-
8
Using the dcli Utility
- 8.1 Overview of the dcli Utility
- 8.2 dcli Syntax
-
8.3
dcli Examples
- 8.3.1 Using dcli to Set up SSH User-equivalence for a Current User
- 8.3.2 Using dcli with the -n Option
- 8.3.3 Using dcli with the -r Option
- 8.3.4 Using dcli with the -v Option
- 8.3.5 Using dcli with the -t Option
- 8.3.6 Using dcli with the -f Option
- 8.3.7 Using dcli with the --vmstat Option
- 8.3.8 Using dcli with the --hidestderr Option
- 8.3.9 Using dcli with the --showbanner Option
- 8.3.10 Using dcli to Change an IORM Plan
- 8.3.11 Using dcli with a Script
- 8.3.12 Using dcli to List Grid Disk Status
- 8.3.13 Using dcli to List Alert History Information
- 8.3.14 Using dcli to List Alert History Where examinedby is Not Set
- 8.3.15 Using dcli to List Current Metric Alert State
- 8.3.16 Using dcli to List Specific Metric Current Objects in a Group
- 8.3.17 Using dcli to List Specific Metric Current Objects
- 8.3.18 Using dcli to List Physical Disks
- 8.3.19 Using dcli to List Cell Disks with Free Space
- 8.3.20 Using dcli to View Alert History
- 8.4 Setting Up SSH User-Equivalence on Oracle Exadata Storage Server
-
9
Setting up Oracle Exadata Storage Snapshots
- 9.1 Before You Begin With Exadata Snapshots
- 9.2 Overview of Exadata Snapshots
- 9.3 Prerequisites for Exadata Snapshot Databases
- 9.4 Sparse Disk Sizing and Allocation Methodology
- 9.5 Refresh Considerations, or Lifecycle of Exadata Snapshots
- 9.6 Using an Oracle Data Guard Standby Database as the Test Master
-
9.7
Managing Exadata Snapshots
- 9.7.1 Creating Sparse Grid Disks
- 9.7.2 Creating an ASM Disk Group for the Sparse Grid Disks
- 9.7.3 Setting Up the Test Master
- 9.7.4 Creating Snapshots
-
9.7.5
Refreshing the (Read-only) Test Master Database
- 9.7.5.1 Drop the Snapshot Databases
- 9.7.5.2 Change the Permissions on the Test Master to Read-Write
- 9.7.5.3 Convert the Test Master Database Back to a Data Guard Replica
- 9.7.5.4 Update the Test Master Database
- 9.7.5.5 Close the Test Master and Make All Test Master Data Files Read-Only
- 9.7.5.6 Re-create All Snapshots
- 9.7.6 Creating a Snapshot Database from Another Snapshot Database
-
9.7.7
Creating Sparse Test Masters from a Single
Full Database Copy
- 9.7.7.1 Task 1: Prepare the Standby Database to Be Used as a Sparse Test Master
- 9.7.7.2 Task 2: Configure the Sparse Test Master and Sparse Files on the Standby Site
- 9.7.7.3 Task 3: Create Full Database Snapshots Using the New Sparse Test Master
- 9.7.7.4 Task 4: Create a New Sparse Test Master Using a Previously Created Sparse Test Master
- 9.7.8 Creating Sparse Test Masters for PDBs
- 9.7.9 Determining All Snapshots Associated with a Test Master
- 9.7.10 Doing a Sparse Copy
- 9.8 Managing Sparse Griddisks
- 9.9 Monitoring Exadata Snapshots Using Database Statistics and Wait Events
- A Upgrading Oracle Exadata System Software
- B Exadata-Specific Background Processes
-
C
Exadata-Specific Information in
Oracle Database Dictionary Views
- C.1 Oracle Database Dictionary Views
-
C.2
Automatic Workload Repository Views
- C.2.1 DBA_HIST_ASM_BAD_DISK
- C.2.2 DBA_HIST_ASM_DISKGROUP
- C.2.3 DBA_HIST_ASM_DISKGROUP_STAT
- C.2.4 DBA_HIST_ASM_DISK_STAT_SUMMARY
- C.2.5 DBA_HIST_CELL_CONFIG
- C.2.6 DBA_HIST_CELL_CONFIG_DETAIL
- C.2.7 DBA_HIST_CELL_DB
- C.2.8 DBA_HIST_CELL_DISKTYPE
- C.2.9 DBA_HIST_CELL_DISK_NAME
- C.2.10 DBA_HIST_CELL_DISK_SUMMARY
- C.2.11 DBA_HIST_CELL_GLOBAL
- C.2.12 DBA_HIST_CELL_GLOBAL_SUMMARY
- C.2.13 DBA_HIST_CELL_IOREASON
- C.2.14 DBA_HIST_CELL_IOREASON_NAME
- C.2.15 DBA_HIST_CELL_METRIC_DESC
- C.2.16 DBA_HIST_CELL_NAME
- C.2.17 DBA_HIST_CELL_OPEN_ALERTS
- D Oracle Exadata System Software Accessibility Recommendations