Enable and Disable log to increase performance for the table in Oracle
Check for the log is enabled or disabled in Oracle
SQL> col table_name for a15 SQL> select table_name,logging from user_tables; TABLE_NAME LOG --------------- --- JOB_HISTORY YES TEST YES EMPLOYEETEST YES JOBS YES
Disable the log of the table:
SQL> alter table jobs nologging; Table altered.
Enable the log of the table:
SQL> alter table jobs logging; Table altered.
Note: Disable the log may help in fixing performance issues during insert or update queries. If your application is using any table which is not important example error log table for maintaining errors which not used to keep production data. You can disable its logging to avoid unnecessary log generation and improve the performance of your database.