AWR Performance: Difference between revisions
Jump to navigation
Jump to search
Created page with "Category:DBCollect {{stub}} = Overview = Sometimes, generating AWR reports can be very slow. This article lists some potential remedies. * Solution 1 <syntaxhighlight lang=sql> alter session set "_push_join_predicate"=false; OR alter session set "_optimizer_push_pred_cost_based" = false; </syntaxhighlight>" |
|||
| Line 10: | Line 10: | ||
<syntaxhighlight lang=sql> | <syntaxhighlight lang=sql> | ||
alter session set "_push_join_predicate"=false; | alter session set "_push_join_predicate"=false; | ||
OR | -- OR | ||
alter session set "_optimizer_push_pred_cost_based" = false; | alter session set "_optimizer_push_pred_cost_based" = false; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 11:19, 13 June 2024
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;