Home / NEWS AND UPDATES / Can Nologging Be Enabled for EBS 12.2?

Can Nologging Be Enabled for EBS 12.2?

Can Nologging Be Enabled for EBS 12.2?

By: Steven Chan | Senior Director

The nologging Oracle database feature is used to enhance performance in certain areas of Oracle E-Business Suite. For example, it may be used during patch installation, and when building summary data for Business Intelligence.

What are the tradeoffs of using nologging?

Use of nologging in an operation means that the database redo logs will contain incomplete information about the changes made, with any data blocks that have been updated during the nologging operation being marked as invalid. As a result, a database restoration to a point in time (whether from a hot backup or a cold backup) may require additional steps in order to bring the affected data blocks up-to-date, and make the restored database usable. These additional steps may involve taking new backups of the associated datafiles, or by dropping and rebuilding the affected objects. The same applies to activation of a standby database.

Can nologging be enabled for EBS 12.2?

Yes.  See the following documentation for additional considerations and operational implications of using nologging:

Related Articles

Source: https://blogs.oracle.com/stevenchan/can-nologging-be-enabled-for-ebs-122

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

NewsAndUpdates-d5668652

EBS 12.2 Certified with Database Release Update 19.19

EBS 12.2 Certified with Database Release Update 19.19 – All Platforms (April 2023)   We …

Leave a Reply