RE: limit temp usage before error or out of space condition?
- From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
- To: Kellyn Pot'vin <kellyn.potvin@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 22 Oct 2013 20:55:58 +0000
Yes, I use resumable already. Just wanted to see if I could catch them before
they suspend. I have lowered the warning threshold on the full condition for
the tablespace. It doesn't look like OEM has anything to monitor temp usage by
query tho. I could write something in perl but I was hoping to avoid having to
build a wheel.
From: Kellyn Pot'vin [mailto:kellyn.potvin@xxxxxxxxx]
Sent: Tuesday, October 22, 2013 1:47 PM
To: oracle-l@xxxxxxxxxxxxx; Josh Collier
Subject: Re: limit temp usage before error or out of space condition?
Look into setting up resumable in your database. .. your life will be so much
better for it. ...:)
Sent from Yahoo Mail on
Android<http://overview.mail.yahoo.com/mobile/?.src=Android>
________________________________
From: Josh Collier
<Josh.Collier@xxxxxxxxxxxx<mailto:Josh.Collier@xxxxxxxxxxxx>>;
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
<oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>;
Subject: limit temp usage before error or out of space condition?
Sent: Tue, Oct 22, 2013 8:38:02 PM
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
