Database Administration (MOSC)

MOSC Banner

explain plan anomoly

edited Apr 10, 2018 2:41PM in Database Administration (MOSC) 10 commentsAnswered ✓

Oracle 11.2.0.4 SE-1 and 12.1.0.2 SE-2, on Win 2012

Two databases, two servers.  11.2 is prod, 12.1 is test, recently upgraded from 11.2.  Still in acceptance testing before upgrading prod.  Question is not about the fact that the two plans are different. I expected that.  But some specifics about the differences are very puzzling.

Here's the setup.  I start with a sql script named 'explain_prod.sql' to run and report the plan:  Note the dynamic naming of the spool file to include the instance name.

delete from plan_tablewhere statement_id = 'MINE';commit;set trimsp on lines 256COL operation   FORMAT A30COL options     FORMAT A15

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