unable to reproduce same execution plan for sql profile with optimizer_dynamic_sampling
Hello Oracle Gurus,
Unable to reproduce same execution plan with hints taken from SQL PROFILE which has "optimizer_dynamic_sampling" to a modified sql.
Both the queries are executed in same db and one by one immediately.Please have a look below and let me know a workaround to reproduce same plan.
SYS:IDB00269>select * from table(dbms_xplan.display_awr('fq0jbjgfxb7ht','1737104956',NULL, 'ADVANCED'));
SQL_ID fq0jbjgfxb7ht
--------------------
SELECT A.EMPLID, A.COMPANY, A.STATE, A.LOCALITY, A.TAX_CLASS,
A.BALANCE_YEAR, A.BALANCE_QTR, A.BALANCE_PERIOD, A.TXGRS_MTD,
A.TXGRS_QTD, A.TXGRS_YTD, A.TAX_MTD, A.TAX_QTD, A.TAX_YTD, A.NLGRS_MTD,