Today I learnt something new, on sql profiles.
Thanks to Kerry Osborne’s blog that let me understand on this stuff
Before going forward have a look at the below plans.
SQL> select * from table(dbms_xplan.display_awr(‘2pg20pzpc6yb7’)); PLAN_TABLE_OUTPUT- —————————————————————————————————– SQL_ID 2pg20pzpc6yb7 ——————– SQL Statement removed intentionally, and it is irrelevant to subject Plan hash value: 526584108 —————————————————————————————————————————– […]
Follow Me!!!