SQL Performance (MOSC)

MOSC Banner

Why sql plan is differet from trace and elect plan_table_output from TABLE (DBMS_XPLAN.DISPLAY_CURSO

edited Jan 30, 2015 12:19PM in SQL Performance (MOSC) 2 commentsAnswered

I had one sql

SELECT pp.prt_process_no

from

  prt_process pp,prw_contr_state pcs,prw_valid_trans pvt where

  pp.prt_process_no > :p1 AND prt_sys_status (pp.prt_status_code) NOT IN

  (:"SYS_B_0",:"SYS_B_1") AND pvt.prw_transition_id = :p2 AND

  pcs.prw_control_id = pvt.prw_control_id AND pp.prt_type_code =

  pcs.prt_type_code AND pp.prt_class_code = pcs.prt_class_code AND

  (pp.prt_subclass_code = pcs.prt_subclass_code) AND (pp.prt_status_code =

  pcs.prt_status_code OR pcs.prt_status_code IS NULL) AND

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