It looks for system changes in the area of database configuration, workload change and SQL change that could have caused the performance problem. An ADDM analysis is started for the two periods. Then the difference between the two periods is measured. Finally, the results are compared according to predefined internal rules.
Increasing the database parameter SGA_TARGET can increase the I/O throughput and thus the WORKLOAD . init.ora parameter changes are albania telegram screening found and changes are suggested. Changes in the hardware and software can be displayed. Suggestions are then made.
We go to the performance page, select AWR, ADDM over comparison period, ADDM analysis. Here you can now compare 2 periods or a current period to the base period. The MMON slave process generates a lock. A check is made to see whether the ADDM report is already running on another instance. If the check is negative, the report is generated.