将表设置为 nologging, 能提高insert速度,是因为产生的Redo最少
在归档模式下,将表调整为NOLOGGING,产生的redo量是最少的!
NOLOGGING的局限在于,如果数据设置了FORCELOGGING,那么表上的属性就会被忽略。例如DG主库上应用了FORCELOGGING MODLE。但是在Oracle 12c Release 2 有了新的FEATURE,或许可以支持 但是没有用过。
Introduction to Direct-Load INSERT
Direct-load INSERT enhances performance during insert operations by formatting and writing data directly into Oracle datafiles, without using the buffer cache. This functionality is similar to that of the Direct Loader utility (SQL*Loader).
Direct-load INSERT appends the inserted data after existing data in a table; free space within the existing data is not reused. Data can be inserted into partitioned or nonpartitioned tables, either in parallel or serially.
check force logging
select force_logging from gv$database
https://danischnider.wordpress.com/2018/02/20/direct-path-insert-and-nologging-with-oracle-12-2/
for temporary table