Oracle-L: RE: Resource Management

From: <Jared.Still_at_radisys.com>
Date: Tue, 06 Aug 2002 16:12:23 -0800
Message-ID: <F001.004AD037.20020806161223@fatcity.com>

I wouldn't do this, especially to Oracle processes.

The kernel scheduler already does a fair job of doing this properly. There are probably specialized cases of where this might be recommended, but I wouldn't think that having a script second guessing the scheduler would be a good idea.

How do you define "too much CPU"?

It could be that the process really needs it.

Jared

"Post, Ethan" <Ethan.Post_at_ps.net>
Sent by: root_at_fatcity.com
08/06/2002 01:43 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Resource Management

and spin and spin...

I suppose it would be easy to write a shell script to monitor for processes
and "nice" them if they are using to much CPU. Anyone ever done this on UNIX, what has been the impact to the database internally? Can using the nice command on one Oracle process have a negative impact on the other processes associated with the instance?

If this was on NT it might not be so easy, then I have to look at the solution below which I still don't know if is possible...

Ethan Post
perotdba (AIM), epost1 (Yahoo)

-----Original Message-----
Sent: Tuesday, August 06, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L

The wheel in my mind continues to spin...

I can think of a way to possibly achieve my goal, If I can force a session into a Resource Management profile from another session which is monitoring
resource consumption then I could catch any session using over "N" CPU minutes and force it into a profile that only gets 20% of the resources for
that particular instance. Have not search the docs hard on this idea yet but is this possible to anyones knowledge?

-----Original Message-----
Sent: Tuesday, August 06, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L

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).

--

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

Author:
INET: Jared.Still_at_radisys.com

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