Muutke küpsiste eelistusi

Oracle Database 12c Release 2 New Features [Pehme köide]

,
  • Formaat: Paperback / softback, 304 pages, kõrgus x laius x paksus: 231x185x18 mm, kaal: 530 g, 80 Illustrations
  • Ilmumisaeg: 04-Aug-2017
  • Kirjastus: McGraw-Hill Education
  • ISBN-10: 125983719X
  • ISBN-13: 9781259837197
Teised raamatud teemal:
Oracle Database 12c Release 2 New FeaturesSuurem pilt
  • Formaat: Paperback / softback, 304 pages, kõrgus x laius x paksus: 231x185x18 mm, kaal: 530 g, 80 Illustrations
  • Ilmumisaeg: 04-Aug-2017
  • Kirjastus: McGraw-Hill Education
  • ISBN-10: 125983719X
  • ISBN-13: 9781259837197
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781259837197.html
Märksõnad:
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality,  authenticity, or access to any online entitlements included with the product.

Leverage the New and Improved Features of Oracle Database 12c

Written by Oracle experts Bob Bryla and Robert G. Freeman, this Oracle Press guide describes the myriad new and enhanced capabilities available in the latest Oracle Database release. Inside, youll find everything you need to know to get up and running quickly on Oracle Database 12c Release 2. Supported by contributions from Oracle expert Eric Yen, Oracle Database 12c Release 2 New Features offers detailed coverage of:

 Installing Oracle Database 12c and Grid Infrastructure  Architectural changes, such as Oracle Multitenant  The most current information on upgrading and migrating to Oracle Database 12c  The pre-upgrade information tool and parallel processing for database upgrades  Oracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File System  Enhanced and new online operations: tables, indexes, and PDBs  Oracle RMAN enhancements, including cross-platform backup and recovery  Oracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far Sync  SQL, PL/SQL, DML, and DDL new features  Improvements to partitioning manageability, performance, and availability  Advanced business intelligence and data warehousing capabilities  Security enhancements, including privileges analysis, data redaction, and new administrative-level privileges  Manageability, performance, and optimization improvements

 
Acknowledgments xiii
Introduction xvi
1 Getting Started with Oracle Database 12c Release 2
1(26)
Downloading Oracle Database 12c Release 2 Components
2(2)
Preparing the Operating System for Oracle Database 12c Release 2
4(8)
Review the Installation Guide and Readme Files
5(1)
Make Sure Your OS Platform Has All Required Updates Installed
6(1)
Make Sure Your Platform Meets the Minimum Requirements
6(3)
Create the Required OS Groups and Users
9(1)
Configure the Kernel Parameters
10(1)
Check for Patches
10(1)
Finish the Preinstall Steps
11(1)
Installing Oracle Database 12c Release 2
12(13)
Prepare the Installation Environment
13(1)
Install Oracle Database 12c Release 2 Using the OUI
13(12)
Installing Oracle Database 12c Release 2 Grid Infrastructure
25(1)
Prepare to Install Oracle Database 12c Release
2(23)
Grid Infrastructure
25(1)
Stage Oracle Database 12c Release 2 Grid Infrastructure
25(1)
Deinstalling Oracle Database 12c Release 2
26(1)
Summary
26(1)
2 Installing or Upgrading to Oracle Database 12c Release 2
27(54)
Installing Oracle Database 12c Release 2 Grid Infrastructure
29(12)
Configure Grid Infrastructure and Start ASM
30(9)
Add the RECO Disk Group Using asmca
39(2)
Creating a New Oracle Database 12c Release 2 Database
41(5)
Upgrading to Oracle Database 12c Release 2: Traditional Architecture
46(24)
Upgrade Paths
46(2)
Preparing for an Upgrade
48(19)
The Last Word on Upgrading the Traditional Architecture
67(1)
In the Event of Failure
68(2)
Upgrading to Oracle Database 12c Release 2: Multitenant Architecture
70(6)
Upgrade Methods for Multitenant Databases in Oracle Database 12c Release 2
71(5)
In the Event of Failure
76(1)
Going...Going...Gone: Deprecated and Desupported Features
76(3)
Features Deprecated in Oracle Database 12c Release 2
77(1)
Features Desupported in Oracle Database 12c Release 2
77(1)
Deprecated Parameters in Oracle Database 12c Release 2
78(1)
Desupported Parameters in Oracle Database 12c Release 2
78(1)
Summary
79(2)
3 Oracle Database 12c Release 2 Multitenant New Features
81(26)
New Features Related to Creating Pluggable Databases
82(7)
Support for Thousands of PDBs for Each Container Database
83(1)
Parallel PDB Creation
83(1)
Hot and Cold Cloning a PDB
83(2)
Creating a PDB with a Default Tablespace
85(1)
Support for Different Character Sets in PDBs
86(2)
PDB Support for Different Database Time Zones
88(1)
PDB Support for Different Database Time Zone Files
89(1)
Moving, Copying, and Migrating PDBs
89(9)
Cloning a PDB in READ WRITE Mode
90(1)
Incrementally Refreshing a Read-Only PDB
90(1)
Flashback a PDB
91(1)
Relocating a PDB
92(2)
Manually Transporting PDBs Across Platforms
94(3)
Using PDB Archive Files when Unplugging a PDB
97(1)
PDB Security: Lockdown Profiles
98(3)
Multitenant Performance-Related New Features
101(5)
Controlling SGA Use at the PDB Level
101(3)
Resource Manager Changes Related to CDBs and PDBs
104(2)
Summary
106(1)
4 Application Containers and Hints Thereof
107(14)
Application Containers
108(10)
Creating the Application Container
109(2)
Creating the Application in the Application Root
111(2)
Creating an Application PDB
113(3)
Installing, Upgrading, and Patching the Application Container
116(1)
Creating the Application Seed
117(1)
Using Hints in the Containers Query
118(1)
Summary
119(2)
5 Administrative, High Availability, and Security New Features
121(36)
Administration
122(9)
Online Table Redefinition
122(7)
Converting Nonpartitioned Tables to Partitioned Tables
129(1)
Creating a New Table with Partition Characteristics
130(1)
High Availability
131(6)
RAC and Grid Infrastructure
132(2)
Automatic Storage Management
134(2)
Sharding
136(1)
Security
137(18)
Encryption and Redaction
137(8)
Database Vault
145(4)
Auditing
149(2)
Privilege Analysis
151(2)
Separation of Duties
153(1)
User and Password Management
154(1)
STIG
155(1)
Summary
155(2)
6 RMAN New Features
157(18)
Table Recovery Enhancements
158(3)
RMAN High Availability and Security Enhancements
161(3)
Using RMAN to Duplicate TDE Tablespaces
162(1)
Cross-Platform Transport Using RMAN
162(1)
Backup and Recovery of Sparse Databases on Exadata
163(1)
Cloud Control, PDB Archives, and RMAN, Oh My!
164(10)
Unplugging a PDB Using RMAN and Cloud Control
164(2)
Plugging In a PDB Using RMAN and Cloud Control
166(8)
Summary
174(1)
7 Performance-Related New Features
175(20)
Monitoring Index Usage
176(5)
DBA_INDEX_USAGE
178(2)
V$INDEX_USAGE_INFO
180(1)
Optimizer Statistics Advisor
181(6)
Rules
183(3)
Findings
186(1)
Recommendations
186(1)
Actions
186(1)
In-Memory Enhancements
187(6)
Initialization Parameters
187(1)
Dynamic Memory Area for In-Memory Objects
188(1)
New In-Memory Objects
189(2)
In-Memory FastStart
191(1)
Compress Join Groups
192(1)
Per-Process PGA Limits
193(1)
Summary
194(1)
8 Compression and Archiving
195(16)
NFS Server in the Database
196(8)
Prerequisites for Setting Up an NFS Server in the Database
196(1)
Creating a DBFS File System
197(3)
Installing NFS Server in the Database
200(1)
Using the NFS Client Interface
200(4)
Tuning NFS Server in the Database
204(1)
OFS Dynamic Performance and Data Dictionary Views
204(1)
Using Advanced Index Compression
204(4)
Using COMPRESS in Oracle Database 11g
205(1)
Using COMPRESS ADVANCED LOW in Oracle Database 12c Release 1
206(1)
Using COMPRESS ADVANCED HIGH
206(2)
Improvements to Hybrid Columnar Compression (HCC)
208(1)
HCC Array Inserts
208(1)
HCC with Automatic Data Optimization (ADO)
208(1)
Summary
209(2)
9 Big Data, Business Intelligence, and Data Warehousing New Features
211(18)
Leveraging New Partitioning Methods
212(14)
Using Interval Partitioning with Subpartitions
214(2)
List Partitioning Enhancements
216(5)
Partitioning External Tables
221(5)
Materialized View Performance Improvements
226(2)
Summary
228(1)
10 Utilities and Scheduler New Features
229(8)
Oracle Data Pump Parallel Metadata Management
230(2)
External Table Access Driver Improvements
232(1)
In-Memory Scheduler Jobs
233(3)
In-Memory Runtime Jobs
234(1)
In-Memory Full Jobs
235(1)
Summary
236(1)
11 New Features for Developers, Report Writers, and Power Users
237(16)
New and Enhanced Functions
238(7)
CAST
238(2)
VALIDATE_CON VERSION
240(2)
LISTAGG
242(3)
Approximate Query Processing
245(3)
Configuring Approximate Query Processing
246(1)
Using Approximate Query Processing
246(2)
Data Dictionary and Data Type Enhancements
248(3)
Identifier Length Changes
248(1)
New Data Dictionary Views
249(2)
Summary
251(2)
12 Integrating with Oracle Enterprise Manager Cloud Control 13c Release 2
253(20)
Configuring a Cloud Control Repository
254(6)
Installing Cloud Control 13c
260(11)
Leveraging New Cloud Control 13c Features
271(1)
Support for Oracle Database 12c Release 2
271(1)
Other Features Worth Mentioning
272(1)
Summary
272(1)
Index 273
Bob Bryla (Plattville, WI) OCP, is an Oracle 8, 8i, 9i, 10g, and 11g Certified Professional with more than 15 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle DBA at Lands End in Dodgeville, Wisconsin. Bob is the co-author of the Oracle Database 11g DBA Handbook from Oracle Press (McGraw-Hill), and the OCA: Oracle 10g Administration I Study Guide (1Z0-042) and OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 from Sybex/Wiley.





Robert G. Freeman is an Oracle Database 10g Oracle Certified Professional that has been working with Oracle databases for well over 15 years. He is a Principle Datababase Engineer for the Church of Jesus Christ of Latter-day Saints in Salt Lake City, Ut. He resides near Salt Lake with his wife, three of his five kids and cats, dogs and an airplane. Robert is the author or co-author of several Oracle Press titles including Oracle9i New Features, Oracle Database 10g New Features, Oracle9i RMAN Backup and Recovery and Portable DBA: Oracle.