Re: How to limit database resources

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Fri, 29 Nov 2002 16:26:34 GMT
Message-ID: <_yMF9.39$ib5.71307@se2-fa199-9.gva.ch.colt.net>

Sybrand Bakker wrote:

> "Knut Talman" <knut.talman_at_mytoys.de> wrote in message
> news:2JnF9.38$ib5.69852_at_se2-fa199-9.gva.ch.colt.net...
> 

>>Is it possible to limit a users CPU utilization so that the user (process)

> 
> can
> 

>>only consume e.g. 60 percent of CPU time? If I specifiy this limit in time

 >>units

>>the call ends after this time. I want that the call takes longer (or runs
>>slower) if it exceeds the limit. Is there any possibility?
>>If not, does anybody know how to do it w/ OS tools?
>>
>>Thank you in advance,
>>
>>Knut
>>Oracle 8.1.7.4/Linux
>>

> 
> 
> 
> Please check out 'create profile' and/or resource plans in your
> documentation.

Thanks, but I already did. AFAIK by using 'create profile' I can only limit users CPU access in time units (100th of second), not percentage. Correct me if I am wrong.

Regards,

Knut Received on Fri Nov 29 2002 - 10:26:34 CST