Hey Kerry, I'll have to give that a shot here. Ain't this list great?! :) Thanks for the improvements!!! Rich > Hi Rich, > > That's a pretty useful idea and script. I think the sql_id of v > $sort_usage view reports the prev_sql_id and not the current sql_id > though (at least it appears so in 10.2.0.4 and 11.2.0.1 in the quick > test I did). Maybe that was intentional. Anyway, the following select > gives me the sql statement causing the temp usage while it is happening. > > SELECT sysdate "TIME_STAMP", vsu.username, vs.sql_id, [snippage] -- //www.freelists.org/webpage/oracle-l