title: sql oracle how to know which part of the query takes long time
body: <p>I have a large script that I'm using to get information about Employees, the script consists of lots of lookups and joins between several tables, I'm wondering, is there anyway that I can know which part of the script or which lookup takes more time and make the script very slow so I can only tune it instead of trying to tune the whole script until I find out which one causing me the trouble.</p>
  
  <p>I'm using oracle 11g. </p>
  
  <p>Thanks in advance. </p>