Page History

...

Oracle offers "direct path load" [1] as the fastest method to populate data after manual file copying. Direct path load can be from both command line utility SQL*Loader to load existing files (resembling Ignite's COPY command), and with conventional SQL, such as INSERT and CREATE TABLE AS SELECT (CTAS). Major highlights:

• SQL parsing phase is skipped in case of SQL*Loader usage
• Page cache is skipped
• Old pages are not changed, data is written to new data blocks
• Multi-block writes and async IO is used to improve throughput
• Table lock is held during data load - writes are not allowed, reads see data before data load start
• Partial indexes are built using separate memory buffers and then merged to existing indexes

[1] https://docs.oracle.com/cd/E11882_01/server.112/e22490/ldr_modes.htm#SUTIL009
[2] https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-tables.html#GUID-134D6EB6-219E-4820-AB54-8C60067A8F0F

...