temporary tablespace
i'll appreciate your help with the follwing scenario:
some days i check the database size and found that the temporary tablespaces have had reach its size limit (20Gb)
I shrink the datafiles associated with the temporary, takoing it back to its size of 1.5Gb
How can i realize the sentences or sessions that are 'consuming' the temporary tablespace ???
This normally occurs by night or on weekends (no batch proceses runs on database)
thanks