SQL Performance (MOSC)

MOSC Banner

unable to reproduce same execution plan for sql profile with optimizer_dynamic_sampling

edited Oct 9, 2016 5:05AM in SQL Performance (MOSC) 6 commentsAnswered ✓

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center