Re: CPU Resource Quota

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 16 Jun 2004 14:04:17 -0700
Message-ID: <1087419877.476812@yasure>

John Wood wrote:

> Sorry I forgot the important info here.
> I am running Oracle 9.2.0.2 on Window 2000 Server.
> Thanks.
> JW
>
> "John Wood" <jwood_at_hotmail.com> wrote in message
> news:wmPzc.57394$%i1.37677_at_edtnps89...
>

>>I read some where that we can set up CPU/Disk IO Resource Quota for a
>>specific Oracle Account.  I have an Oracle Account mainly to run some
>>Statistical Reports.  I would like to limit this accounts 's  CPU Quota

>
> not
>

>>to have more than 50%.  This way we can allocate at least half of the
>>resources to other Users for update.
>>
>>Could someone give me an idea how to do it; and what should I watch for

>
> with
>

>>this kind of setup.
>>
>>Thanks.
>>
>>JW.

Look at DBMS_RESOURCE_MANAGER
http://www.psoug.org/reference/dbms_res_mgr.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed Jun 16 2004 - 16:04:17 CDT