OCP 12c Upgrade 1Z0-060 Exam Guide

Your ultimate guide to passing the OCP 12c Upgrade 1Z0-060 Exam
Preview in Mapt

OCP 12c Upgrade 1Z0-060 Exam Guide

Advait Deo, Indira Karnati

Your ultimate guide to passing the OCP 12c Upgrade 1Z0-060 Exam
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $47.99
Save 79%
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$59.99
$29.99 p/m after trial
RRP $47.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


OCP 12c Upgrade 1Z0-060 Exam Guide Book Cover
OCP 12c Upgrade 1Z0-060 Exam Guide
$ 47.99
$ 10.00
DevOps in Finance Book Cover
DevOps in Finance
$ 35.99
$ 10.00
Buy 2 for $20.00
Save $63.98
Add to Cart

Book Details

ISBN 139781787126602
Paperback630 pages

Book Description

This guide will get Oracle admins up to date with the latest developments in Oracle 12c. It includes all the necessary information that you need to implement in your existing systems.

All of the information in this book has been handpicked to help you study for the Oracle 12c upgrade exam. Each chapter has been written with the objective of helping you pass this exam with ease. Content in this book is aligned with the objectives of the exam, making it really easy to follow the course content. Every example mentioned in this book has been tried and tested in actual environment. Real-world examples will help you learn about new features such as multitenant containers database architecture, managing containers, pluggable databases, database administration enhancements, database auditing, tuning, backup, and flashback enhancements.

You will also learn about storage enhancements, security updates, tuning, troubleshooting, and backup enhancements. This book also covers section 2 of the exam course making this book a complete guide for passing OCP 12c upgrade exam 1Z0-060.

Table of Contents

Chapter 1: Getting Started with Oracle 12c
Installation and configuration using OUI and DBCA
Using EM Database Express
Emergency monitoring and Real-Time ADDM
Real-Time ADDM
Generating ADDM compare period
Diagnosing performance issues using ASH enhancements
Summary
Chapter 2: Multitenant Container Database Architecture
Challenges with non-container databases
Benefits of multitenant architecture
Root and multitenant architecture
Organization of CDBs and PDBs
Local users and common users
Local and common roles and privileges
Creating and configuring a CDB
Post-CDB creation
Creating PDBs
Summary
Chapter 3: Managing CDBs and PDBs
Establishing connection to CDB/PDBs
Creating services
Connecting to CDBs
Starting up and shutting down a CDB/PDB
Object link and metadata link
Container data objects
Enabling a common user to access data in a specific PDB
Managing tablespaces in a CDB/PDB
Managing users and privileges in CDB/PDB
Summary
Chapter 4: Information Lifecycle Management and Storage Enhancements
Information lifecycle management
Typical lifecycle of data
How automatic data optimization works
Enabling heat maps
Enabling ADO policies
Evaluating and executing ADO policies
Checking execution details of ADO policies
Enabling and disabling ADO policies
Moving data files online
Moving partitions online
In-database archiving and temporal validity
In-database archiving
Temporal validity and temporal history
Summary
Chapter 5: Auditing, Privilege Analysis and Data Redaction
Unified auditing
Enabling unified auditing mode
Creating and enabling unified audit policy
Using administrative privileges
Privilege analysis
Oracle Data Redaction
Types of data redaction
Creating a redaction policy
How Oracle data redaction affects tables and views
Altering the default full data redaction value
Restrictions on data redaction
Enabling and disabling data redaction policies
Exempting users from data redaction
Viewing data redaction policies details
Summary
Chapter 6: Database Tuning and Troubleshooting
Real-time database operation monitoring
Database operation
SQL tuning
Enhanced features of statistics gathering
Adaptive SQL plan management
Summary
Chapter 7: Backup and Flashback Enhancements
Performing a backup of CDB and PDB
Performing recovery of CDB and PDB
Performing a flashback of CDB
Using RMAN enhancements
Automatic table recovery using RMAN
Implementing new features of Flashback Data Archive
Summary
Chapter 8: Database Administration Enhancements
Resource manager
Managing resources between PDBs
Viewing CDB resource plan directives
Managing CDB resource plans
PDB resource plans
Enhancements in creating resource manager plan directives
Multi-process, multi-threaded Oracle architecture
Smart flash cache enhancements
Index and table enhancements
Online redefinition - tables with VPD
Online redefinition - dml_lock_timeout
Advanced row compression and compression advisor
Enhanced online DDL capabilities
ADR and network enhancements
Summary
Chapter 9: Miscellaneous New Features
Oracle data pump enhancements
SQL Loader enhancements
Partitioning enhancements
Index enhancements for partitioned tables
Oracle Database Migration Assistant for Unicode
SecureFile LOB enhancements
The row limiting clause
Extended data types
Summary
Chapter 10: Core Administration
Fundamentals of DB architecture
Memory architecture of the Oracle database
Oracle database process architecture
Shared server architecture and dedicated server architecture
Installing and configuring a database
Monitoring database errors and alerts
Perform daily administration tasks
Apply and review patches
Backup and recover the database
Implement flashback technology
Relocate SYSAUX occupants
Create a default permanent tablespace
Use secure file LOBs
Use Direct NFS
Summary
Chapter 11: Performance Management
Design the database layout for optimal performance
Monitoring performance
Managing memory
Analysing and identifying performance issues
SQL performance analyzer
Cardinality feedback
Adaptive cursor sharing
The purpose of adaptive cursor sharing
Implement application tuning
Summary
Chapter 12: Storage
Managing database structures
Administering ASM
Managing ASM disks and disk groups
Managing an ASM instance
Managing VLDB
Implementing space management
Summary
Chapter 13: Security
Develop and implement a security policy
Configure and manage auditing
Create the password file
Implement column and tablespace encryption
Summary

What You Will Learn

  • All of the new features of the Oracle 12c database that you are required to know for the OCP Upgrade Exam 1Z0-060
  • New multitenant architecture introduced in Oracle 12c and how it works
  • Monitor complex database operations and use the new enhanced SQL tuning features to tune bad SQLs
  • Manage data over time using information life cycle management
  • Make your data more secure by implementing new enhanced auditing
  • Learn new security features and how to implement encryption to secure your data
  • Explore how backup and flashback works with new multitenant architecture
  • Performance management techniques that will analyze and tune your database

Authors

Table of Contents

Chapter 1: Getting Started with Oracle 12c
Installation and configuration using OUI and DBCA
Using EM Database Express
Emergency monitoring and Real-Time ADDM
Real-Time ADDM
Generating ADDM compare period
Diagnosing performance issues using ASH enhancements
Summary
Chapter 2: Multitenant Container Database Architecture
Challenges with non-container databases
Benefits of multitenant architecture
Root and multitenant architecture
Organization of CDBs and PDBs
Local users and common users
Local and common roles and privileges
Creating and configuring a CDB
Post-CDB creation
Creating PDBs
Summary
Chapter 3: Managing CDBs and PDBs
Establishing connection to CDB/PDBs
Creating services
Connecting to CDBs
Starting up and shutting down a CDB/PDB
Object link and metadata link
Container data objects
Enabling a common user to access data in a specific PDB
Managing tablespaces in a CDB/PDB
Managing users and privileges in CDB/PDB
Summary
Chapter 4: Information Lifecycle Management and Storage Enhancements
Information lifecycle management
Typical lifecycle of data
How automatic data optimization works
Enabling heat maps
Enabling ADO policies
Evaluating and executing ADO policies
Checking execution details of ADO policies
Enabling and disabling ADO policies
Moving data files online
Moving partitions online
In-database archiving and temporal validity
In-database archiving
Temporal validity and temporal history
Summary
Chapter 5: Auditing, Privilege Analysis and Data Redaction
Unified auditing
Enabling unified auditing mode
Creating and enabling unified audit policy
Using administrative privileges
Privilege analysis
Oracle Data Redaction
Types of data redaction
Creating a redaction policy
How Oracle data redaction affects tables and views
Altering the default full data redaction value
Restrictions on data redaction
Enabling and disabling data redaction policies
Exempting users from data redaction
Viewing data redaction policies details
Summary
Chapter 6: Database Tuning and Troubleshooting
Real-time database operation monitoring
Database operation
SQL tuning
Enhanced features of statistics gathering
Adaptive SQL plan management
Summary
Chapter 7: Backup and Flashback Enhancements
Performing a backup of CDB and PDB
Performing recovery of CDB and PDB
Performing a flashback of CDB
Using RMAN enhancements
Automatic table recovery using RMAN
Implementing new features of Flashback Data Archive
Summary
Chapter 8: Database Administration Enhancements
Resource manager
Managing resources between PDBs
Viewing CDB resource plan directives
Managing CDB resource plans
PDB resource plans
Enhancements in creating resource manager plan directives
Multi-process, multi-threaded Oracle architecture
Smart flash cache enhancements
Index and table enhancements
Online redefinition - tables with VPD
Online redefinition - dml_lock_timeout
Advanced row compression and compression advisor
Enhanced online DDL capabilities
ADR and network enhancements
Summary
Chapter 9: Miscellaneous New Features
Oracle data pump enhancements
SQL Loader enhancements
Partitioning enhancements
Index enhancements for partitioned tables
Oracle Database Migration Assistant for Unicode
SecureFile LOB enhancements
The row limiting clause
Extended data types
Summary
Chapter 10: Core Administration
Fundamentals of DB architecture
Memory architecture of the Oracle database
Oracle database process architecture
Shared server architecture and dedicated server architecture
Installing and configuring a database
Monitoring database errors and alerts
Perform daily administration tasks
Apply and review patches
Backup and recover the database
Implement flashback technology
Relocate SYSAUX occupants
Create a default permanent tablespace
Use secure file LOBs
Use Direct NFS
Summary
Chapter 11: Performance Management
Design the database layout for optimal performance
Monitoring performance
Managing memory
Analysing and identifying performance issues
SQL performance analyzer
Cardinality feedback
Adaptive cursor sharing
The purpose of adaptive cursor sharing
Implement application tuning
Summary
Chapter 12: Storage
Managing database structures
Administering ASM
Managing ASM disks and disk groups
Managing an ASM instance
Managing VLDB
Implementing space management
Summary
Chapter 13: Security
Develop and implement a security policy
Configure and manage auditing
Create the password file
Implement column and tablespace encryption
Summary

Book Details

ISBN 139781787126602
Paperback630 pages
Read More

Read More Reviews

Recommended for You

Oracle Advanced PL/SQL Developer Professional Guide Book Cover
Oracle Advanced PL/SQL Developer Professional Guide
$ 35.99
$ 10.00
PostgreSQL 9 Administration Cookbook - Second Edition Book Cover
PostgreSQL 9 Administration Cookbook - Second Edition
$ 47.99
$ 10.00
Oracle Enterprise Manager 12c Administration Cookbook Book Cover
Oracle Enterprise Manager 12c Administration Cookbook
$ 29.99
$ 10.00
Oracle Database 11gR2 Performance Tuning Cookbook Book Cover
Oracle Database 11gR2 Performance Tuning Cookbook
$ 32.99
$ 10.00
R: Recipes for Analysis, Visualization and Machine Learning Book Cover
R: Recipes for Analysis, Visualization and Machine Learning
$ 71.99
$ 10.00
Oracle WebLogic Server 12c Advanced Administration Cookbook Book Cover
Oracle WebLogic Server 12c Advanced Administration Cookbook
$ 29.99
$ 10.00