AWR Performance

From Dirty Cache Wiki
Revision as of 11:19, 13 June 2024 by Bart (talk | contribs) (→‎Overview)
Jump to navigation Jump to search

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;