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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.