Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Temporary tablespace growth

Temporary tablespace growth

From: hgha <houman_at_globe-tekcorp.com>
Date: 6 Dec 2006 11:50:53 -0800
Message-ID: <1165434653.874453.255160@l12g2000cwl.googlegroups.com> 





my temporary tablespace has grown to it's maximum (32GB) in two
separate incidents. is there


any way I can find out what query has been responsible for this growth?
V$sort_usage doesn't tell me much.



thanks
Received on Wed Dec 06 2006 - 13:50:53 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US