Oracle database 12c release 2 performance tuning tips and techniques /

Proven Database Optimization Solutions--Fully Updated for Oracle Database 12c Release 2 Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 12c Release 2 Pe...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Niemiec, Richard J. (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : McGraw-Hill Education, [2017]
Temas:
Oracle (Computer file)
Relational databases.
Bases de données relationnelles.
Relational databases
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Title Page
  • Copyright Page
  • About the Author
  • Contents at a Glance
  • Contents
  • Acknowledgments
  • Introduction
  • 1 Introduction to Oracle Database 12c R1 & R2 New Features (DBA and Developer)
  • Oracle Database 12cR1 (12.1.0.1)
  • Increased Size Limit to 32K for VARCHAR2 and NVARCHAR2
  • Partial Indexes
  • Invisible Columns
  • Multiple Indexes on the Same Column List
  • Fetch First x Rows
  • Pluggable Databases (PDBs)
  • Oracle Database Cloud Service (Database as a Service)
  • PDB Level: MEMORY_LIMIT and MEMORY_MINIMUM (12cR2)
  • Change Compression at Import Time
  • Adaptive Query Optimization
  • PGA_AGGREGATE_LIMIT
  • Concurrent Execution for UNION/UNION ALL
  • Invoker Rights Function Can Be Results Cached
  • New DBMS_UTILITY. EXPAND_SQL_TEXT
  • Default for Columns Based on Sequence
  • Multiple SSD Devices for Smart Flash Cache
  • Concurrent Cost-Based Optimizer Statistics Gathering
  • Enhanced System Statistics
  • Resource Manager for Runaway Queries
  • Automatic Data Optimization (ADO)
  • Global Index Maintenance: Drop and Truncate Partition Operations
  • ASM Disk Scrubbing
  • Online Capability Improvements
  • Data Guard Improvements
  • RMAN Improvements
  • Oracle Database 12cR1 (12.1.0.2)
  • In-Memory Database
  • Advanced Index Compression
  • Automatic Big Table Caching
  • FDA Support for Container Databases
  • Full Database Caching
  • JSON Support
  • FIPS 140 Parameter for Encryption
  • PDB Subset Cloning
  • Rapid Home Provisioning-Creating "Gold Images"
  • Oracle Database 12cR2 (12.2)
  • Application Development
  • Enhanced Features to Reduce Costs and Issues for Migration to Oracle
  • Availability
  • Big Data
  • Compression and Archiving
  • Oracle RAC and Grid Infrastructure
  • Security
  • New Background Processes in 12c
  • Exadata-New with Exadata X6!
  • Version Comparison Chart
  • New Features Review
  • References
  • 2 Basic Index Principles (Beginner Developer and Beginner DBA)
  • Basic Index Concepts
  • Invisible Indexes
  • Multiple Types of Indexes on the Same Column(s)
  • Concatenated Indexes
  • Suppressing Indexes
  • Using the NOT EQUAL Operators:,!=
  • Using IS NULL or IS NOT NULL
  • Using LIKE
  • Using Functions
  • Comparing Mismatched Data Types
  • Selectivity
  • The Clustering Factor
  • The Binary Height
  • Additional Details Concerning BLEVEL and Index Height
  • Using Histograms
  • Fast Full Scans
  • Skip-Scans
  • Types of Indexes
  • B-Tree Indexes
  • Bitmap Indexes
  • Hash Indexes
  • Index-Organized Tables
  • Reverse Key Indexes
  • Function-Based Indexes
  • Partitioned Indexes
  • New 12cR2 Features for Partitioned Indexes
  • Bitmap Join Indexes
  • Fast Index Rebuilding
  • Rebuilding Indexes Online
  • Tips Review
  • References
  • 3 Pluggable Databases, Disk Implementation Methodology, and ASM (DBA)
  • Pluggable Databases (New in Oracle 12c)
  • CDB or PDB Created Objects
  • Creating a PDB: Many Ways to Do It
  • Great Pluggable Database Commands

Ejemplares similares