Aw: limit temp usage before error or out of space condition?
- From: "Kurt Franke" <kurt-franke@xxxxxx>
- To: Josh.Collier@xxxxxxxxxxxx
- Date: Wed, 23 Oct 2013 15:21:14 +0200 (CEST)
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Aw: limit temp usage before error or out of space condition? - Kurt Franke
