Re: Quota on TEMP

  • From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
  • To: davidsharples@xxxxxxxxx
  • Date: Wed, 20 Sep 2006 10:06:58 -0700 (PDT)

What you are suggesting is good and valid, and I don't
disagree.

But back to my question - is there a way to set quota
for Temp (using Res Mgr, profile, anything out there,
that someone may have used)?



--- David Sharples <davidsharples@xxxxxxxxx> wrote:

> so what if the user who is using all the temp gets
> their query stopped, you
> are doing the same thing by wanting to limit their
> resources.
> 
> You could change your on call if the 1652 was for
> this temp tablespace
> 
> Dont let the tempfiles expand was his point
> 
> 
> On 20/09/06, Deepak Sharma
> <sharmakdeep_oracle@xxxxxxxxx> wrote:
> >
> > By creating a separate Temp, how will that stop
> the
> > ORA-1652, for a run-away query?  The difference is
> > that with ORA-1652, our on-call gets called, and
> if we
> > had a quota, then the User would get a message
> (quota
> > exceeded).  The intention is to avoid the 1st one.
> >
> > What did you mean by limit the sizes of Tempfiles?
> >
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l


Other related posts: