limit temp usage before error or out of space condition?
From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 22 Oct 2013 20:38:02 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817EA523B_at_M1EXCHMB11.mmi.local>
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,
Date: Tue, 22 Oct 2013 20:38:02 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817EA523B_at_M1EXCHMB11.mmi.local>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 22 2013 - 22:38:02 CEST