title: How expensive is a query in terms of TEMP tablespace?
body: <p>I have a few sprocs that execute some number of more complex queries and liberally use collections.  </p>
  
  <p>My DBA is complaining that they occasionally consume a S#$%ton of in-memory TEMP tablespace.</p>
  
  <p>I can perform optimizations on the queries but i also wish to be as noninvasive as possible and to do this i need to see the effects my changes have on the TEMP tablespace.</p>
  
  <p>QUESTION:</p>
  
  <p><strong>How can i see what cost my query has on the TEMP tablespace?</strong></p>
  
  <p>One thing to consider is i dont have DBA access.</p>
  
  <p>Thanks in advance.</p>