RE: limit temp usage before error or out of space condition?
From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Wed, 23 Oct 2013 16:27:03 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817EA55BA_at_M1EXCHMB11.mmi.local>
this is a good idea!
-----Original Message-----
From: Kurt Franke [mailto:kurt-franke_at_web.de] Sent: Wednesday, October 23, 2013 6:21 AM To: Josh Collier
Cc: oracle-l_at_freelists.org
Subject: Aw: limit temp usage before error or out of space condition?
Date: Wed, 23 Oct 2013 16:27:03 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817EA55BA_at_M1EXCHMB11.mmi.local>
this is a good idea!
-----Original Message-----
From: Kurt Franke [mailto:kurt-franke_at_web.de] Sent: Wednesday, October 23, 2013 6:21 AM To: Josh Collier
Cc: oracle-l_at_freelists.org
Subject: Aw: limit temp usage before error or out of space condition?
Josh,
you may use different temporary tablespaces for users which run batch processes, and users, which will do data analyzing using arbitrary queuries. Of course, build more user-groups with different temporary tablespaces is possible.
regards
kf
> 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 Wed Oct 23 2013 - 18:27:03 CEST