Resource Management

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Tue, 06 Aug 2002 10:28:26 -0800
Message-ID: <F001.004AC6A2.20020806102826@fatcity.com>

Trying to do a little reading up on Resource Management and the examples are clear that I could break everyone up in a database into groups and give 1 group %50 cpu time, one 30% and one 20%. However, it is not clear to me if I can take 2 different database instances and enforce that neither use more than %50 of total CPU on the box. My guess is that I can not do this and what is being managed is only the total CPU cycles being granted to each Oracle instance and not total CPU time. The idea being if we put two customers on the same box in the same domain how can we prevent customer A from chewing up too much CPU. It would be nice if I could say something like...

If any process exceeds a total of 2 minutes CPU time then lower the priority on this session by a factor of N. I can use profiles to say "If CPU time exceeds 2 minutes then say goodbye" but I am not sure customers would appreciate that.

Your ideas are welcome.

Thanks,
Ethan Post
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 06 2002 - 13:28:26 CDT