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