Oracle 11g – How to force a sql_id to use a plan_hash_value using SQL Baselines | rmoff rmoff June 28, 2011 Oracle 11g – How to force a sql_id to use a plan_hash_value using SQL Baselines Filed under: etl, oracle, performance, plan management, sql plan baseline — rmoff @ 14:13 Here’s a scenario that’ll be depressingly … Читать далее
generate pivot script: use info in awr to build a graph result :
https://bushmelev-aa.ru/owncloud/index.php/s/vdqNlAqNqIPLxil materials 12c SPM
generate logminer list: build catalog find out transaction content: commit\rollback: if archivelogs are on tape:
plan to make a script with time range as input values open in browser: add for mac os x add for linux:
NOTE: RUN ON STANDBY IF POSSIBLE =)
Hello, how to add custom metric to EM with «bad» sql and how-to diagnose results: usefull links first: Creating an Information Publisher Report based on a Custom Metric Extension whats_changed.sql based on this material add custom metric with query from query with performance degradation running more than 5 sec after all Enjoy the message like … Читать далее
find query with performance degradation running more than 5 sec : original by Kerry Osborne