AWR Performance

This article is a stub. You can help us by expanding it.

Overview

Sometimes, generating AWR reports can be very slow. This article lists some potential remedies.

• Solution 1

Reference: Oracle Support Note 2929370.1

alter session set "_push_join_predicate"=false;
-- OR
alter session set "_optimizer_push_pred_cost_based" = false;

• Solution 2

Reference: Oracle Support Note 2148489.1

DBMS_STATS.DELETE_SYSTEM_STATS('NOWORKLOAD');
DBMS_STATS.GATHER_SYSTEM_STATS(GATHERING_MODE => 'NOWORKLOAD');