title: Oracle hard parse
body: <p>We've a preparedStatement which needs to do multiple operations on the db, so all those sql statements are enclosed in a BEGIN-END block like</p>
  
  <pre><code>BEGIN
   DELETE FROM...WHERE A=?..
   UPDATE TABLE...WHERE B=?..
  END;
  </code></pre>
  
  <p>But many reviewers said this will result in a hard parse. From my understanding hard parse is when an sql is not found in the shared pool, then the syntax, execution plan ..everything needs to be calculated again, but here shouldn't Oracle treat them as individual sql statements.
  How can I find out that oracle will do a hard parse or not on a given sql statement?</p>