3 Replies Latest reply: Feb 12, 2013 6:48 AM by 698658 RSS

    dynamic sampling every executions or every hard parse ?

    698658
      Hi,
      let's say we are on latest 11.2.0.3.5 ,and for some none parallel queries oracle is using dynamic sampling level 2 (default) .
      How do You think, is dynamic sampling used for every executions (even with the same query / same plan) or only if we are duing hard parse ,and
      no dynamic sampling with soft parses (no hard parses generaly) .
      Regards
      GregG