Re: Quota on TEMP

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Wed, 20 Sep 2006 10:06:58 -0700 (PDT)
Message-ID: <20060920170658.23449.qmail@web52806.mail.yahoo.com>

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_at_gmail.com> 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_at_yahoo.com> 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

Received on Wed Sep 20 2006 - 12:06:58 CDT