My Oracle Support Banner

Extent Sizes for Sort, Direct Load and Parallel Operations (PCTAS & PDML) (Doc ID 50592.1)

Last updated on NOVEMBER 23, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


This note describes how storage is allocated for sort, direct and 
parallel operations in Oracle7 and Oracle8. 

Each main operation is described in its own section with a summary of
when and where space is allocated.


Scope & Application
It is intended to clarify how and when temporary space is allocated 
during processing. 

NOTE: Within this note the 'Logging' information indicates whether redo is
      generated for the operation or not. This is independent of the database
      logging mode (ARCHIVELOG or NOARCHIVELOG mode). If the database is
      in NOARCHIVELOG mode then any redo generated will be lost when the 
      online logs wrap.

      Please note this article does NOT currently discuss LOCALLY MANAGED
      tablespaces which are available from Oracle8i onwards.    
      These are discussed in Note:93771.1 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.