Parallel Processing in Oracle Database 12c

  • : 12cPP
  • : 1 .
  • : 104 500 11 175
    , 01.01.2022 01.11.2030

30.09.2022
104 500
Online

:

Oracle 12c. , , Oracle 11g Release 1 and 2..

:

  • SQL ,
  • ,
  • ,

:

:

  • Database Resource Manager,
  • SQL , ,
  • ,
  • SQL
  • ,
  • , , , in-memory
  • , , RAC c
  • , , , , DOP ( )
  • Oracle customer support

:

  • Oracle Database: SQL Tuning for Developers

:

  • ?
  • Query Coordinator ( ) parallel execution (PX) ( )
  • producer/consumer (/)

DOP ( )

  • ,
  • SELECT
  • SELECT hash join
  • SELECT partition wise join ( )
  • DML

DOP

  • DOP DOP
  • DOP
  • DOP
  • DOP
  • SELECT DOP
  • DOP RAC

  • DOP
  • Database Resource Manager
  • ,

In-Memory

  • In-Memory
  • SELECT in-memory
  • In-Memory
  • In-memory PX

  • DataPump export/import
  • SQL*Loader
  • :

, ,

  • ,
  • DOP DOP
  • ,

DBRM (Database Resource manager)

  • DBRM ( )
  • ,

 

: Parallel Processing in Oracle Database 12c



* -

:

:

: