Oracle Database 12c: Implement Partitioning

  • : 12cIP
  • : 2 .
  • : 126 500 22 350
    , 01.01.2022 01.11.2030

:

Oracle 12c.   Oracle University .

:

  •  
  •  
  •      
  •   lob , (nested)
  • , , Oracle  12c Release  1.

:

  •  

:

  • ,
  • , Oracle RDBMS
  • .
  • , alter.
  • (overhead ), .
  • .
  • Oracle Enterprise Manager

:

  • SQL Fundamentals
  • Basic SQL Tuning
  • Basic Database Administration
  • Oracle Database: SQL Workshop I

:

  • Basic Data Modeling and Relational Database Design
  • Basic knowledge of Data Warehousing Design
  • Oracle Database: SQL Tuning for Developers

:

Partitioning Concepts

  • VLDB Manageability and Performance Constraints
  • Manual Partitions Versus Partitioning
  • Partitioned Tables and Indexes
  • Table Versus Index Partitioning
  • Partitioned Indexes
  • Partitioning Strategies: Single-Level Partitioning
  • Partitioning Strategies: Composite Partitioning
  • Oracle Partitioning History

Implementing Partitioned Tables

  • Table, Partition, and Segment Relations
  • Creating Partitions with Enterprise Manager
  • CRE ATE TABLE Statement with Partitioning
  • Logical and Physical Attributes
  • Partition Strategy Declaration: Single-Level Partitioning
  • Specifying Partition Attributes
  • Range Partitioning
  • Interval Partitioning

Implementing Partitioned Indexes

  • Partitioned Indexes
  • Partitioned Index Attributes: Global or Local
  • Partitioned Index Attributes: Prefixed or Nonprefixed
  • Global Indexes
  • Local Prefixed Indexes
  • Local Nonprefixed Index
  • Index Partitioning and Type Matrix
  • Specifying an Index with Table Creation

Maintenance of Partitioned Tables and Indexes

  • Maintenance: Overview
  • Table and Index Interaction During Partition Maintenance
  • Modifying the Logical Properties of Tables and Indexes
  • Modifying Partition Properties on the Table
  • Using the ALT ER TABLE and ALT ER INDEX Commands
  • Renaming a Partition
  • Partition Storage Changes
  • Moving a Partition

Partitioning Administration and Usage

  • Using Partitioned Tables
  • Pruning Rules
  • Static and Dynamic Pruning
  • Pruning Tips
  • Static Partition Pruning and Star Query
  • Dynamic Partition Pruning and Star Query
  • Collecting Statistics for Partitioned Objects
  • ANALYZE and Partitioned Objects

Partitioning and Workload Types

  • Partitioning in Data Warehouses
  • Using Materialized Views for Summary Management
  • Partitioning and Materialized Views
  • Maintaining Partitions of a Materialized View
  • Partition Change Tracking (PCT) Refresh
  • PCT Refresh: Requirements
  • When Is PCT Refresh Used?
  • Partition Key or Partition Marker?

 

: Oracle Database 12c: Implement Partitioning



* -

:

:

: