Tuning data loading operations

TUNING DATA LOADING OPERATIONS

User direct path loading The buffer cache is bypassed and data is loaded directly into the datafiles. This can
significantly improve the loading performance.


select
table_name
,logging
from user_tables
where table_name = 'F_REGS';

TABLE_NAME,LOGGING

F_REGS1,YES

Disable logging for table

SQL> alter table f_regs nologging;

table altered

If NOLOGGING is specified, then a minimal amount of redo is generated.