title: How to prevent parallel execution on query with no hint
body: <p>I'm trying to improve performance to specific query in my DB.
  One of the tables in the query, has parallel degree which is greater than 1 in dba_tables.</p>
  
  <p>I founded that if I add a hint of </p>
  
  <blockquote>
    <p>NO_PARALLEL</p>
  </blockquote>
  
  <p>my query back to run very fast.</p>
  
  <p>The problem is that I don't want to touch and change the source of query.</p>
  
  <p>So I found this article:</p>
  
  <p><a href="http://intermediatesql.com/oracle/how-to-add-a-hint-to-oracle-query-without-touching-its-text/" rel="nofollow noreferrer">http://intermediatesql.com/oracle/how-to-add-a-hint-to-oracle-query-without-touching-its-text/</a></p>
  
  <p>which explain how to use alias with block names to create a profile and actually execute the hint with no touching the query.</p>
  
  <p>I used it before for use an index even the optimizer decide to execute FTS.</p>
  
  <p>But in case of parallel - I just didn't understand how to do that.</p>
  
  <p>I just want to add the action that will simulate the no_parallel hint on the whole query.</p>
  
  <p>Additionally, I don't want to set the parallel parameter or alter the session.. just change for this query.</p>
  
  <p>Someone?</p>
  
  <p>Thanks.</p>