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 7.0.16.0 and laterGen 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.
Purpose
Purpose
~~~~~~~
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
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
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |