Oracle Database Discussions

Hi ,

I have encountered abnormal temp tablespace size increase (till the filesystem limit,and then database halted.) yesterday.I now want to find the sql statement which caused it .The data base version is 10.2.0.5 in HPUX. I could worked out query as below,but this doesn't serve the purpose.SORTS_TOTAL is Cumulative number.

set lines 200
col MODULE for a28
col SQL_TEXT for a80 wrap
select snap_id,DBA_HIST_SQLTEXT.SQL_ID,MODULE,SORTS_TOTAL, SORTS_DELTA,SQL_TEXT from DBA_HIST_SQLSTAT,DBA_HIST_SQLTEXT where snap_id between 1761 and 1766 and DBA_HIST_SQLSTAT.SQL_ID=DBA_HIST_SQLTEXT.SQL_ID order by 4;

this event occurred at 1210Hrs and AWR snap-id during this period is 1763 (12-13Hrs).I suspect the query had started before this period.

can somebody help me find the sql stament.

Thanks.