I noticed dmann wrote a question, "Finding SQL Statements hitting TEMP Space limit...", and mentioned that he was using cron to schedule a periodic query that showed use of TEMP space.
On SQL Server, I generally use DMO to get database and table size information but I haven't the faintest idea how to do that in Oracle.
What tables would be involved and what might a couple of useful queries be? Things I might want to know would be tablespace sizes, allocations within them by user and table.
Would someone provide suggestions or samples?