Enable and Disable log generation for the table in Oracle

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.

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply