SQL interface to obtain the temporary space usage (tables, hash, sorts...)
A DBA and possibly a programmer needs an easy way to monitor who is responsible for the temporary space usage.
Currently it's possible a user may be consuming a lot of temporary space and impacting other sessions, without the DBA being able to quick and easily identify the session responsible.
Other reports (from IIUG mailing list) and another RFE (36245) mentions the need for programmers to be able to find out the current session's temp tables (onstat -g ses shows this).
The definitive solution for this should be an SQL interface showing:
- session ID
- object name
- object type (explicit temp table, implicit temp table, hash join, sort ...?)
- used space
- chunk/dbspace being used
- owner nam
- ??? (PID and others, but probably thos can be gathered with joins)
This should supersede RFE ID 36245 and this includes the request for that RFE and more.