For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Is there a query to see what objects (tables) are consuming TEMP and UNDO tablespaces?
For example, if my temp space blows out to 90G, how can I find out what is filling it? Same for undo...
Oracle 12c on Windoz 2k8r2