Re: Quota on TEMP

  • From: Remigiusz SokoÅowski <rems@xxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 21 Sep 2006 16:07:55 +0200

Tanel Poder wrote:

>That sounds like a good enhancement request.
>
>One dirty workaround would be to just to periodically monitor the temporary
>segment users and if anybody without proper permission is using more than X
>megabytes of temp space, then just kill their session.
>
>Also you could enable the resumable space allocation database wide and write
>an AFTER SUSPEND trigger which scans for worst temp space users on firing
>and kills those sessions ;) *evil grin*
>
>But I think a better question is - why do you allow users to run such
>queries in the database?
>
>Either size the tablespace properly or try to limit running such queries by
>other means. If it's a production database - nobody should be able to run
>ad-hoc SQL there anyway, especially if it's known to cause problems..
>
>Tanel.
>
> 
>
>  
>
>>-----Original Message-----
>>From: oracle-l-bounce@xxxxxxxxxxxxx 
>>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Deepak Sharma
>>Sent: Thursday, September 21, 2006 01:07
>>To: davidsharples@xxxxxxxxx
>>Cc: hkchital@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
>>Subject: Re: Quota on TEMP
>>
>>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)?
>>
>>    
>>
>
>  
>
Well, some obvious attempt to the problem could be creating and
assigning different temp spaces to
different users - this however doesn't necessarily save disk space,
though less important users will
get ORA-1652 earlier than those important ones


-- 
---------------------------------------
Remigiusz Sokolowski <rems@xxxxxxxx>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL  v. 4.x
Oracle v. 10.x
---------------------------------------

--
http://www.freelists.org/webpage/oracle-l


Other related posts: