FORCE LOGGING On Oracle

Before you read this article, I suggest you read the article “What is logging_clause On Oracle (LOGGING or NOLOGGING)” to better understand the concept of LOGGING.

 

You may need to force all objects in the database to work in the LOGGING structure, especially if you are transferring data to the standby.

 

But in some cases you can choose NOLOGGING so that the operation to be performed is faster, or does not consume resources (for example, the INDEX REBUILD operation).

 

With the help of the following script you can force all objects in the database to work in LOGGING or NOLOGGING structure.

 

 

With the help of the following scripts you can use the FORCE LOGGING option on the database and tablespace basis.

 

 

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *