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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
