RE: limit temp usage before error or out of space condition?
From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 22 Oct 2013 20:55:58 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817EA5294_at_M1EXCHMB11.mmi.local>
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_at_ymail.com] Sent: Tuesday, October 22, 2013 1:47 PM
To: oracle-l_at_freelists.org; Josh Collier Subject: Re: limit temp usage before error or out of space condition?
From: Josh Collier <Josh.Collier_at_banfield.net<mailto:Josh.Collier_at_banfield.net>>; To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>; Subject: limit temp usage before error or out of space condition? Sent: Tue, Oct 22, 2013 8:38:02 PM
Date: Tue, 22 Oct 2013 20:55:58 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817EA5294_at_M1EXCHMB11.mmi.local>
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_at_ymail.com] Sent: Tuesday, October 22, 2013 1:47 PM
To: oracle-l_at_freelists.org; 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_at_banfield.net<mailto:Josh.Collier_at_banfield.net>>; To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>; 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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 22 2013 - 22:55:58 CEST