Overview of adop finalize phase

Finalize Parameters:

finalize_mode=(full|quick) [default: quick]

Quick mode will provide the shortest execution time, by skipping non-essential actions.

Full mode performs additional actions such as gathering statistics that may improve performance after cutover.

Example - Perform additional optimizations during Finalize:

adop phase=finalize finalize_mode=full

Using full mode after applying a major patch can help maintain optimal system performance.

What happening finalize phase

Collected below information in log files

Adop phase=finalize

Checking for pending hotpatch session.

Checking for pending cleanup session.

Continuing with existing session [Session ID: 22].

Verifying data dictionary.

Running finalize phase database actions.

Log: @ADZDSHOWLOG.sql

Finalize System

Executing FINALIZE actions

Compiling invalid objects.

Generating log report: adzdshowlog.out

The finalize phase completed successfully.

Comments

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to compile forms in R12.2