Last night the TEMP tablespace maxed out on one of your databases:
ORA-1652: unable to extend temp segment by 64 in tablespace TEMP
It almost doubled in size to 8GB in a matter of minutes. I was trying to use SQL PI to find out what happened and if there is anything that I need to do to stop it happening again. But I can't seem to find anything in SQL PI that correlates with this event. Can SQL PI help me understand this better?
After applying John's suggestion in order to narrow down the time range then,
In the performance tree select
Instance -> Files -> select your tempDB file -> expand to see the SQL Statements that generated the most TEMP Reads/Writes for this temp file.
That did help :-) There is so much hidden in here!
I was able to find the culprit by using the Files -> TempFile tree that George suggested and as shown in the screenshot. Perfect!