title: Set Query Timeout value in oracle database for a web application
body: <p>As I'm working on a new web application project in visual studio 2003, my application has queries which is being executed. This application is connected to a DB of type Oracle. </p>
  
  <p>Now, what I want to do is to set the query time out value for all queries in this application to be very large value, or infinity, so when executing a query fails, it will not directly re executing it, because if it is executing it many times, and keeps executing it, the DB overload ! </p>
  
  <p>We noticed that around 60 sessions are opened and executing this query at the same time, if it fails to execute! </p>
  
  <p>Now, my questions: </p>
  
  <ol>
  <li><p>Since I'm new to oracle, Where to find the query time out variable and change it to a very large value? And what about if I have many queries in my application? Do I need to change the time out value for each single query? </p></li>
  <li><p>I want to know the difference between HTTP/SOAP time out value and the query time out value? </p></li>
  </ol>
  
  <p>Thank you guys ! </p>
  
  <hr>
  
  <p>I search to use CommandTimeout property which is in the OracleCommand Class, but I don't find it. 
  Are there other ways to use this property to set timeout? </p>