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

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