RE: limit temp usage before error or out of space condition?

From: Iotzov, Iordan <>
Date: Tue, 22 Oct 2013 16:54:42 -0400
Message-ID: <>

There is TEMP_SPACE_ALLOCATED column in V$ACTIVE_SESSION_HISTORY (11g+) that you can use to find out what session uses excessive temp space. Make sure you have the appropriate licenses for using V$ACTIVE_SESSION_HISTORY view.

Creating a monitor for temp space could be a bit challenging because a "bad" query can consume lots of temp space in a very short period of time. You need frequent sampling interval and fast reflexes (assuming there would be human involvement) to make it work.

Iordan Iotzov

Check out SmartSource Xpress, our new iPad app! Follow us on Twitter | Like us on Facebook

-----Original Message-----

From: [] On Behalf Of Josh Collier Sent: Tuesday, October 22, 2013 4:38 PM
Subject: limit temp usage before error or out of space condition?

Does anyone have any ideas how to limit temp usage before the query at hand fills up the temp tablespace and then suspends everyone else until the condition is cleared? Is there a way to monitor queries that are using too much temp and send an email? Maybe in OEM? Thanks for your thoughts,

Josh C.


This message and its attachments may contain legally privileged or confidential information. It is intended solely for the named addressee. If you are not the addressee indicated in this message (or responsible for delivery of the message to the addressee), you may not copy or deliver this message or its attachments to anyone. Rather, you should permanently delete this message and its attachments and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of News America Incorporated or its subsidiaries must be taken not to have been sent or endorsed by any of them. No warranty is made that the e-mail or attachment(s) are free from computer virus or other defect.

-- Received on Tue Oct 22 2013 - 22:54:42 CEST

Original text of this message