Well, I'm not sure how to inspect the temp tablespace other than from the filesystem itself. I have it configured on its own disk. Usually the disk space ebbs and flows with query activity. Since we've been crashing however, it never reclaims the disk that was in use just before the crash. So our temp space 'floor" keeps getting higher and higher.
At least that is what it has been doing for the past week or two, and what it looked like this morning. Now that the database has been back up for 8 or 9 hours following this controlled restart, I just went to look at it, and all of the temp space has been reclaimed - for the first time since the crashing started. ... Interesting...
