Home Page Icon
Home Page
Table of Contents for
Title Page
Close
Title Page
by Bob Bryla, Roopesh Ramklass, John Watson
OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition
Cover
Title Page
Copyright Page
Dedication
About the Authors
Contents
Introduction
Part I Getting Started
Chapter 1 Installing Oracle Database Software
Plan for an Oracle Database Software Installation
Supported Platforms
Obtain the Oracle Database Software
User Accounts
Disk Space and Directories
The Prerequisite Checks
Install the Oracle Database Software
The OUI Inventory
The OUI Dialog: Interactive Install
Silent Install and Response Files
Windows and Linux Variations
Two-Minute Drill
Plan for an Oracle Database Software Installation
Install the Oracle Database Software
Self Test
Self Test Answers
Chapter 2 Creating an Oracle Database Using DBCA
Create a Database by Using the Database Configuration Assistant
The Instance, the Database, and the Data Dictionary
Using the Database Configuration Assistant to Create a Database
The DBCA Dialog
Generate Database Creation Scripts by Using DBCA
Generating the Scripts
The Creation Scripts
The Initialization Parameter File
Manage Database Design Templates by Using DBCA
Configure Database Options by Using DBCA
Two-Minute Drill
Create a Database by Using the Database Configuration Assistant
Generate Database Creation Scripts by Using DBCA
Manage Database Design Templates by Using DBCA
Configure Database Options by Using DBCA
Self Test
Self Test Answers
Chapter 3 Installing Oracle Grid Infrastructure for a Stand-Alone Server
Configure Storage for Oracle Automatic Storage Management
GI Architecture
ASM Architecture
ASM Disks
Creating ASM Disks
Install Oracle Grid Infrastructure for a Stand-Alone Server
Two-Minute Drill
Configure Storage for Oracle Automatic Storage Management
Install Oracle Grid Infrastructure for a Stand-Alone Server
Self Test
Self Test Answers
Chapter 4 Using Oracle Restart
Use Oracle Restart to Manage Components
Administering the Oracle Restart Processes
Administering Registered Resources
The Restart Capability
Two-Minute Drill
Use Oracle Restart to Manage Components
Self Test
Self Test Answers
PART II SQL
Chapter 5 DDL and Schema Objects
Use the Client Tools
SQL*Plus
SQL Developer
Categorize the Main Database Objects
Object Types
Users and Schemas
Naming Schema Objects
Object Namespaces
List the Data Types that Are Available for Columns
Create a Simple Table
Creating Tables with Column Specifications
Creating Tables from Subqueries
Altering Table Definitions After Creation
Dropping and Truncating Tables
Create and Use Temporary Tables
Indexes
Why Indexes Are Needed
Types of Indexes
Creating and Using Indexes
Modifying and Dropping Indexes
Constraints
The Types of Constraints
Defining Constraints
Constraint State
Constraint Checking
Views
Why Use Views at All?
Simple and Complex Views
CREATE VIEW, ALTER VIEW, and DROP VIEW
Synonyms
Sequences
Creating Sequences
Using Sequences
Two-Minute Drill
Categorize the Main Database Objects
List the Data Types that Are Available for Columns
Create a Simple Table
Create and Use Temporary Tables
Indexes
Constraints
Views
Synonyms
Sequences
Self Test
Self Test Answers
Chapter 6 DML and Concurrency
Describe Each Data Manipulation Language Statement
INSERT
UPDATE
DELETE
TRUNCATE
MERGE
DML Statement Failures
Control Transactions
Database Transactions
Executing SQL Statements
Transaction Control: COMMIT, ROLLBACK, SAVEPOINT, SELECT FOR UPDATE
Explain DML and Undo Data Generation
Monitor and Administer Undo Data
Error Conditions Related to Undo
Parameters for Undo Management
Sizing and Monitoring the Undo Tablespace
Temporary Undo
Creating and Managing Undo Tablespaces
Describe the Difference Between Undo Data and Redo Data
Configure Undo Retention
Configuring Undo Retention to Support Long-Running Queries
Flashback Query and Undo Retention
Describe the Locking Mechanism and Data Concurrency Management
Shared and Exclusive Locks
The Enqueue Mechanism
Automatic and Manual Locking
Monitor and Resolve Locking Conflicts
The Causes of Lock Contention
Detecting Lock Contention
Solving Lock Contention
Deadlocks: A Special Case
Two-Minute Drill
Describe Each Data Manipulation Language Statement
Control Transactions
Explain DML and Undo Data Generation
Monitor and Administer Undo Data
Describe the Difference Between Undo Data and Redo Data
Configure Undo Retention
Describe the Locking Mechanism and Data Concurrency Management
Monitor and Resolve Locking Conflicts
Self Test
Self Test Answers
Chapter 7 Retrieving, Restricting, and Sorting Data Using SQL
Explain the Capabilities of SQL SELECT Statements
Introducing the SQL SELECT Statement
The DESCRIBE Table Command
Capabilities of the SELECT Statement
Data Normalization
Data Modeling
Entities and Relations
Rows and Tables
Create the Demonstration Schemas
Users and Schemas
The HR and OE Schemas
Demonstration Schema Creation
Execute a Basic SELECT Statement
Syntax of the Primitive SELECT Statement
Rules Are Meant to Be Followed
SQL Expressions and Operators
NULL Is Nothing
Limit the Rows Retrieved by a Query
The WHERE Clause
Comparison Operators
Boolean Operators
Precedence Rules
Sort the Rows Retrieved by a Query
The ORDER BY Clause
The SQL Row-Limiting Clause
Ampersand Substitution
Substitution Variables
Define and Verify
Two-Minute Drill
Explain the Capabilities of SQL SELECT Statements
Execute a Basic SELECT Statement
Limit the Rows Retrieved by a Query
Sort the Rows Retrieved by a Query
Ampersand Substitution
Self Test
Self Test Answers
Chapter 8 Single-Row and Conversion Functions
Describe and Use Character, Number, and Date Functions in SQL
Defining a Function
Types of Functions
Using Case Conversion Functions
Using Character Manipulation Functions
Using Numeric Functions
Working with Dates
Describe Various Types of Conversion Functions Available in SQL
Conversion Functions
Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
Using the Conversion Functions
Apply Conditional Expressions in a SELECT Statement
Nested Functions
Conditional Functions
Two-Minute Drill
Describe Various Types of Conversion Functions Available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
Apply Conditional Expressions in a SELECT Statement
Self Test
Self Test Answers
Chapter 9 Group Functions
Describe the Group Functions
Definition of Group Functions
Using Group Functions
Group Data Using the GROUP BY Clause
Creating Groups of Data
The GROUP BY Clause
Grouping by Multiple Columns
Nested Group Functions
Include or Exclude Grouped Rows Using the HAVING Clause
Restricting Group Results
The HAVING Clause
Two-Minute Drill
Describe the Group Functions
Group Data Using the GROUP BY Clause
Include or Exclude Grouped Rows Using the HAVING Clause
Self Test
Self Test Answers
Chapter 10 SQL Joins
Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
Types of Joins
Joining Tables Using ANSI SQL Syntax
Qualifying Ambiguous Column Names
The NATURAL JOIN Clause
The JOIN USING Clause
The JOIN ON Clause
N-Way Joins and Additional Join Conditions
Nonequijoins
Join a Table to Itself Using a Self-Join
Joining a Table to Itself Using the JOIN . . . ON Clause
View Data That Does Not Meet a Join Condition by Using Outer Joins
Inner versus Outer Joins
Left Outer Joins
Right Outer Joins
Full Outer Joins
Generate a Cartesian Product of Two or More Tables
Creating Cartesian Products Using Cross Joins
Two-Minute Drill
Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
Join a Table to Itself Using a Self-Join
View Data that Does Not Meet a Join Condition Using Outer Joins
Generate a Cartesian Product of Two or More Tables
Self Test
Self Test Answers
Chapter 11 Subqueries and Set Operators
Define Subqueries
Describe the Types of Problems that the Subqueries Can Solve
Use of a Subquery Result Set for Comparison Purposes
Star Transformation
Generate a Table from Which to SELECT
Generate Values for Projection
Generate Rows to Be Passed to a DML Statement
Describe the Types of Subqueries
Single- and Multiple-Row Subqueries
Correlated Subqueries
Write Single-Row and Multiple-Row Subqueries
Using the EXISTS Condition
Null Results in a Subquery
Describe the Set Operators
Sets and Venn Diagrams
Set Operator General Principles
Use a Set Operator to Combine Multiple Queries into a Single Query
The UNION ALL Operator
The UNION Operator
The INTERSECT Operator
The MINUS Operator
More Complex Examples
Control the Order of Rows Returned
Two-Minute Drill
Define Subqueries
Describe the Types of Problems that the Subqueries Can Solve
Describe the Types of Subqueries
Write Single-Row and Multiple-Row Subqueries
Describe the Set Operators
Use a Set Operator to Combine Multiple Queries into a Single Query
Control the Order of Rows Returned
Self Test
Self Test Answers
PART III DBA1
Chapter 12 Architectural Overview of Oracle Database 12c
List the Architectural Components of an Oracle Database
Single-Instance Database Architecture
Distributed Systems Architectures
Explain the Memory Structures
The Database Buffer Cache
The Log Buffer
The Shared Pool
The Large Pool
The Java Pool
The Streams Pool
Describe the Background Processes
SMON, the System Monitor
PMON, the Process Monitor
DBWn, the Database Writer
LGWR, the Log Writer
CKPT, the Checkpoint Process
MMON, the Manageability Monitor
MMNL, the Manageability Monitor Light
MMAN, the Memory Manager
LREG, the Listener Registration Process
ARCn, the Archiver
RECO, the Recoverer Process
Some Other Background Processes
Explain the Relationship Between Logical and Physical Storage Structures
The Physical Database Structures
The Logical Database Structures
The Data Dictionary
Two-Minute Drill
List the Architectural Components of an Oracle Database
Explain the Memory Structures
Describe the Background Processes
Explain the Relationship Between Logical and Physical Storage Structures
Self Test
Self Test Answers
Chapter 13 Instance Management
Use Database Management Tools
Working with SQL*Plus
Log On as a Normal or Privileged User
Working with Database Express
Understand Initialization Parameter Files
Static and Dynamic Parameter Files
Static and Dynamic Parameters and the Initialization Parameter File
The Basic Parameters
Changing Parameters
Start Up and Shut Down an Oracle Database Instance
Starting the Database Listener
Database Startup and Shutdown
View the Alert Log and Access Dynamic Performance Views
The Alert Log
The DDL Log
The Dynamic Performance Views
Two-Minute Drill
Use Database Management Tools
Understand Initialization Parameter Files
Start Up and Shut Down an Oracle Database Instance
View the Alert Log and Access Dynamic Performance Views
Self Test
Self Test Answers
Chapter 14 Oracle Networking
Configure Oracle Net Services
Oracle Net and the Client-Server Paradigm
Establishing a Session
Creating a Database Listener
Dynamic Service Registration
Shared Server
Use Tools for Configuring and Managing the Oracle Network
The Net Manager
The Net Configuration Assistant
The Listener Control Utility
The TNS_ADMIN Environment Variable
Configure Client-Side Network
Easy Connect Name Resolution
Local Naming Name Resolution
Directory Naming and External Naming
Testing Oracle Net Connectivity
Understand Database Resident Connection Pooling
Configure Communication Between Databases
Two-Minute Drill
Configure Oracle Net Services
Use Tools for Configuring and Managing the Oracle Network
Configure Client-Side Network
Understand Database Resident Connection Pooling
Configure Communication Between Databases
Self Test
Self Test Answers
Chapter 15 Oracle Storage
Describe the Storage of Table Row Data in Blocks
The Oracle Data Storage Model
Segments, Extents, Blocks, and Rows
Create and Manage Tablespaces
Creating Tablespaces
Altering Tablespaces
Dropping Tablespaces
Extent Management
Segment Space Management
Oracle Managed Files
Explain How Oracle Database Server Automatically Manages Space
Segment Space Assignment
Automatic Segment Space Management
Save Space by Using Compression
Proactively Monitor and Manage Tablespace Space Usage
Use the Segment Advisor
Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
Manage Resumable Space Allocation
Two-Minute Drill
Describe the Storage of Table Row Data in Blocks
Create and Manage Tablespaces
Explain How Oracle Database Server Automatically Manages Space
Save Space by Using Compression
Proactively Monitor and Manage Tablespace Space Usage
Use the Segment Advisor
Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
Manage Resumable Space Allocation
Self Test
Self Test Answers
Chapter 16 Oracle Security
Create and Manage Database User Accounts
User Account Attributes
Authentication Methods
Creating Accounts
Grant and Revoke Privileges
System Privileges
Object Privileges
Create and Manage Roles
Creating and Granting Roles
Predefined Roles
Enabling Roles
Privilege Analysis
Create and Manage Profiles
Password Profile Limits
Creating and Assigning Profiles
Explain DBA Responsibilities for Security and Auditing
Reasons for Auditing
Auditing Techniques
Enable Standard Database Auditing and Unified Auditing
Enable Standard Auditing
Enable Unified Auditing
Two-Minute Drill
Create and Manage Database User Accounts
Grant and Revoke Privileges
Create and Manage Roles
Create and Manage Profiles
Explain DBA Responsibilities for Security and Auditing
Enable Standard Database Auditing and Unified Auditing
Self Test
Self Test Answers
Chapter 17 Moving and Re-organizing Data
Describe Ways to Move Data
Create and Use Directory Objects
Use SQL*Loader to Load Data from a Non-Oracle Database
Using SQL*Loader
SQL*Loader Express Mode
Use External Tables to Move Data via Platform-Independent Files
Explain the General Architecture of Oracle Data Pump
Use Data Pump Export and Import to Move Data Between Oracle Databases
Capabilities
Using Data Pump with the Command-Line Utilities
Tablespace Export and Import
Use Data Pump in a Multitenant Environment
Export from Non-CDB and Import into PDB
Export and Import Between PDBs
Export from PDB and Import into Non-CDB
Full Transportable Export and Import
Transporting a Database Over the Network
Use SQL*Loader in a Multitenant Environment
Two-Minute Drill
Describe Ways to Move Data
Create and Use Directory Objects
Use SQL*Loader to Load Data from a Non-Oracle Database
Use External Tables to Move Data via Platform-Independent Files
Explain the General Architecture of Oracle Data Pump
Use Data Pump Export and Import to Move Data Between Oracle Databases
Use Data Pump in a Multitenant Environment
Use SQL*Loader in a Multitenant Environment
Self Test
Self Test Answers
Chapter 18 The AWR and the Alert System
Manage the Automatic Workload Repository
Gathering AWR Statistics
Managing the AWR
Use the Automatic Database Diagnostic Monitor
Describe and Use the Advisory Framework
The Memory Advisors
The SQL Advisors
The Automatic Undo Advisor
The Mean Time to Recover Advisor
The Data Recovery Advisor
The Segment Advisor
The SQL Repair Advisor
Set Alert Thresholds
Alert Condition Monitoring and Notifications
Setting Thresholds
Use Automated Tasks
The Autotasks
Controlling the Autotasks
Two-Minute Drill
Manage the Automatic Workload Repository
Use the Automatic Database Diagnostic Monitor
Describe and Use the Advisory Framework
Set Alert Thresholds
Use Automated Tasks
Self Test
Self Test Answers
Chapter 19 Performance Tuning
Use Enterprise Manager to Monitor Performance
A Performance Tuning Methodology
Performance Monitoring Data
The Database Express Performance Pages
Use Automatic Memory Management
PGA Memory Management
SGA Memory Management
Automatic Memory Management
Use the Memory Advisor to Size Memory Buffers
Manage Optimizer Statistics
Object Statistics
How the Optimizer Uses Statistics
Gathering Statistics Manually
Use the SQL Tuning Advisor
The Capabilities of the SQL Tuning Advisor
The SQL Tuning Advisor API: The DBMS_SQLTUNE Package
Use the SQL Access Advisor to Tune Workload
The Capabilities of the SQL Access Advisor
Using the SQL Access Advisor with DBMS_ADVISOR
Two-Minute Drill
Use Enterprise Manager to Monitor Performance
Use Automatic Memory Management
Use the Memory Advisor to Size Memory Buffers
Manage Optimizer Statistics
Use the SQL Tuning Advisor
Use the SQL Access Advisor to Tune Workload
Self Test
Self Test Answers
Chapter 20 The Resource Manager
Configure the Database Resource Manager
The Need for Resource Management
The Resource Manager Architecture
Resource Manager Configuration
Access and Create Resource Plans
CPU Method
Use of the Ratio CPU Method
The Active Session Pool Method
Limiting the Degree of Parallelism
Controlling Jobs by Execution Time
Terminating Sessions by Idle Time
Restricting Generation of Undo Data
Monitor the Resource Manager
Two-Minute Drill
Configure the Database Resource Manager
Access and Create Resource Plans
Monitor the Resource Manager
Self Test
Self Test Answers
Chapter 21 The Scheduler
Use Oracle Scheduler to Simplify Management Tasks
The Scheduler Architecture
Scheduler Objects
Use Job Chains to Perform a Series of Related Tasks
Use Scheduler Jobs on Remote Systems
Use Advanced Scheduler Features to Prioritize Jobs
Using Job Classes
Using Windows
Two-Minute Drill
Use Oracle Scheduler to Simplify Management Tasks
Use Job Chains to Perform a Series of Related Tasks
Use Scheduler Jobs on Remote Systems
Use Advanced Scheduler Features to Prioritize Jobs
Self Test
Self Test Answers
Part IV DBA2
Chapter 22 Configuring the Database for Backup and Recovery
Possible Failures and Their Resolution
Failure Categories
Oracle Backup and Recovery Solutions
Instance Recovery and the Impossibility of Database Corruption
Checkpoints and the Redo Log
The Checkpointing Mechanism
Protecting the Online Redo Log Files
Archivelog Mode and the Archiver Processes
Backup and Recovery: Configuration
Configure the Fast Recovery Area
Configure ARCHIVELOG Mode
Two-Minute Drill
Possible Failures and Their Resolution
Checkpoints and the Redo Log
Configure the Fast Recovery Area
Configure ARCHIVELOG Mode
Configure Control Files and Redo Log Files for Recoverability
Self Test
Self Test Answers
Chapter 23 Back Up with RMAN
Backup Theory and Basic Syntax
Backup Concepts
RMAN Basic Syntax
Persistent RMAN Settings
Some Advanced RMAN Capabilities
The Recovery Catalog
Create and Use RMAN Stored Scripts
Incremental Backups
Other Capabilities
Two-Minute Drill
Create Consistent Database Backups
Back Up Your Database Without Shutting It Down
Create Incremental Backups
Automate Database Backups
Manage Backups and the RMAN Repository
Use Various RMAN Backup Types and Strategies
Perform Full and Incremental Backups
Use Techniques to Improve Backups
Self Test
Self Test Answers
Chapter 24 Restore and Recover with RMAN
Perform Complete and Incomplete Recovery
Restore and Recovery in One Page
Using the RMAN RESTORE and RECOVER Commands
Performing Complete Recovery of a Noncritical Datafile
Performing Complete Recovery of a Critical Datafile
Performing Incomplete Recovery Using RMAN
Recovering Using Incrementally Updated Backups
Switching to Image Copies for Fast Recovery
Perform Recovery for Spfiles, Controlfiles, and Online Redo Log Files
Restoring the Spfile from the Autobackup
Restoring the Controlfile
Recovering from a Lost Redo Log Group
Backing Up and Restoring the Password File
Recovering from a Lost Tempfile
Two-Minute Drill
Perform Complete and Incomplete Recovery
Perform Recovery for Spfiles, Controlfiles, and Online Redo Log Files
Perform Recovery of Tempfiles
Self Test
Self Test Answers
Chapter 25 Diagnosing Failures
Describe the Automatic Diagnostic Workflow
Understanding the ADR
Using the ADRCI Tool
Understanding Alerts, Problems, and Incidents
Using the Health Monitor
Handle Block Corruption
Block Corruption
Using Block Media Recovery
Using the Data Recovery Advisor
Two-Minute Drill
Describe the Automatic Diagnostic Workflow
Handle Block Corruption
Self Test
Self Test Answers
Chapter 26 Flashback
Describe the Flashback Technologies
Flashback Database
Flashback Query, Transaction, and Table
Flashback Drop
Flashback Data Archive
When to Use Flashback Technology
Use Flashback to Query Data
Basic Flashback Query
Flashback Table Query
Flashback Versions Query
Flashback Transaction Query
Flashback and Undo Data
Perform Flashback Table Drop Operations
The Implementation of Flashback Drop
Using Flashback Drop
Managing the Recycle Bin
Perform Table Recovery from Backups
Describe and Use Flashback Data Archive
Perform Flashback Database
Flashback Database Architecture
Configuring Flashback Database
Monitoring Flashback Database
Using Flashback Database
Two-Minute Drill
Describe the Flashback Technologies
Use Flashback to Query Data
Perform Flashback Table Operations
Perform Table Recovery from Backups
Describe and Use Flashback Data Archive
Perform Flashback Database
Self Test
Self Test Answers
Chapter 27 Duplicating a Database
Describe and Use Transportable Tablespaces and Databases
Configuring Transportable Tablespaces
Transporting Tablespaces
Transporting a Database
Duplicate a Database
Using a Duplicate Database
Duplicate from the Active Database
Duplicate from Backup
Two-Minute Drill
Describe and Use Transportable Tablespaces and Databases
Choose a Technique for Duplicating a Database
Create a Backup-Based Duplicate Database
Duplicate a Database
Self Test
Self Test Answers
Chapter 28 Encrypting, Securing, Monitoring, and Tuning RMAN Backups
Create RMAN-Encrypted Backups
Configuring and Using Transparent Encryption
Using Password Encryption
Using Dual-Mode Encryption
Configure and Use Oracle Secure Backup
Installing and Configuring Oracle Secure Backup
Using RMAN with Oracle Secure Backup
Miscellaneous obtool Commands
Monitor and Tune RMAN Performance
Monitoring RMAN Sessions and Jobs
Tuning RMAN Performance
Identifying Backup and Restore Steps
Parallelizing Backupsets
Understanding RMAN Multiplexing
Tuning RMAN Channels
Tuning the BACKUP Command
Two-Minute Drill
Create RMAN-Encrypted Backups
Configure and Use Oracle Secure Backup
Tune RMAN Performance
Self Test
Self Test Answers
Part V Upgrades and Multitenant
Chapter 29 Upgrading Oracle Database Software and Migrating Data
Describe Upgrade Methods
Software Upgrade
Database Upgrade: DBUA or Manual
Describe Data Migration Methods
Describe the Upgrade Process
Migrate Data by Using Oracle Data Pump
Two-Minute Drill
Describe Upgrade Methods
Describe Data Migration Methods
Describe the Upgrade Process
Migrate Data by Using Oracle Data Pump
Self Test
Self Test Answers
Chapter 30 Upgrading an Oracle Database
Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
Oracle Label Security and Oracle Data Vault
Oracle Warehouse Builder
Use the Pre-Upgrade Information Tool Before Performing an Upgrade
Prepare the New Oracle Home Prior to Performing an Upgrade
Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant
Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
Migrate to Unified Auditing
Perform Postupgrade Tasks
Two-Minute Drill
Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
Use the Pre-Upgrade Information Tool Before Performing an Upgrade
Prepare the New Oracle Home Prior to Performing an Upgrade
Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant
Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
Migrate to Unified Auditing
Perform Post-Upgrade Tasks
Self Test
Self Test Answers
Chapter 31 Multitenant Container and Pluggable Database Architecture
Describe the Multitenant Container Database Architecture
Multitenant Concepts
The Drivers for Multitenant
The CDB and the Root Container
PDBs: Pluggable Containers
Explain Pluggable Database Provisioning
Techniques for Provisioning Pluggable Containers
Communications Between Containers
Two-Minute Drill
Describe the Multitenant Container Database Architecture
Explain Pluggable Database Provisioning
Self Test
Self Test Answers
Chapter 32 Creating and Managing Multitenant Container and Pluggable Databases
Create a Container Database
Use DBCA to Create a CDB
Using SQL*Plus to Create a CDB
Create Pluggable Containers
Using PDB$SEED to Create a New PDB
Cloning a PDB to Create a New PDB
Plug a Non-CDB into a CDB
Plug an Unplugged PDB into a CDB
Unplug and Drop a PDB
Migrate a Pre-12.1 Non-CDB Database to CDB
Establish Connections to CDBs and PDBs
Understanding CDB and PDB Service Names
Creating Services for CDBs or PDBs
Switching Connections Within a CDB
Start Up and Shut Down a CDB and Open and Close PDBs
CDB Instance Startup
Open and Close a PDB
CDB Instance Shutdown
Automating PDB Startup
Changing PDB Status
Evaluate the Impact of Parameter Value Changes
Understanding the Scope of Parameter Changes
Using ALTER SYSTEM in a Multitenant Environment
Two-Minute Drill
Create a Container Database
Create Pluggable Containers
Migrate a Pre-12.1 Non-CDB Database to CDB
Establish Connections to CDBs and PDBs
Start Up and Shut Down a CDB and Open and Close PDBs
Evaluate the Impact of Parameter Value Changes
Self Test
Self Test Answers
Chapter 33 Managing Storage, Security, Availability, and Performance in a CDB and PDBs
Space Management in a Multitenant Environment
Tablespace Architecture
Using CREATE TABLESPACE
Default Permanent and Temporary Tablespaces in a PDB
Manage Common and Local Users, Roles, and Privileges
Common and Local Users
Grant Privileges Commonly and Locally
Manage Common and Local Roles
Enable Common Users to Access Data in Specific PDBs
Audit in the Multitenant Environment
Multitenant Backup and Recovery
Back Up a CDB and Individual PDBs
Restore and Recovery
Duplicate PDBs Using RMAN
Mulitenant Performance Monitoring and Tuning
Tuning the Instance
Using Memory Advisors
Manage Allocation of Resources Between PDBs and Within a PDB
Using Shares to Manage Inter-PDB Resources
Creating and Modifying Resource Manager Plans
Perform Database Replay
Capture Source Database Workloads
Process Workloads on the Target System
Replay Workloads on Target CDB: Consolidated Replay
Two-Minute Drill
Manage Permanent and Temporary Tablespaces in CDB and PDBs
Manage Common and Local Users
Manage Common and Local Privileges
Manage Common and Local Roles
Enable Common Users to Access Data in Specific PDBs
Perform Backups of a CDB and PDBs
Recover PDB from PDB Datafiles Loss
Use Data Recovery Advisor
Duplicate PDBs Using RMAN
Monitor Operations and Performance in a CDB and PDBs
Manage Allocation of Resources Between PDBs and Within a PDB
Perform Database Replay
Self Test
Self Test Answers
Appendix About the Download
System Requirements
Installing and Running Total Tester
About Total Tester
Technical Support
Glossary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
About the Authors
Next
Next Chapter
Copyright Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset