IBM Workload Manager (WLM)

Hi List,

Does anyone have experience in using IBM's Workload Manager together with Oracle?

I'm with a consulting client, where server-consolidation is intended. This involves appr. 180 Oracle databases. Some of them 1 instance/1 server, max. is now 22 instances/server. appr. No OPS is used. Versions: 7.3.4, 8.1.x. 60 servers are used now. Goal is to reduce the # of servers with 40-60%. Replacement of the server farm by a reduced number of high-end servers is one of the options, but starting with the consolidation process within the current range of servers is considered as well. All databases will be migrated to 8.1.7 before consolidation takes place. HW/OS is RS6000/AIX, both 4.3.3 and 5.2. Oracle 9i is still under investigation. Applications vvary from Peoplesoft to Siebel to tailor-made software. There is an in-house development department, so there are development, test and production databases. Servers have mixed use: I've seen servers running development, test AND production instances, not necessarily of the same application! Storage is EMC.

One of the ideas is using IBM's WLM to prevent the instances on 1 server damaging each others performance. Not to slice too small HW among too much instances, but to prevent one instance from grabbing too much recources on the cost of other instances.

>From IBM's doc's I got the following information: As from maintenance
level 8 on AIX 4.3.3, and on 5.2, WLM allows manual assignment of processes to classes. Before this feature classes could only be assigned based on program-name or username, which is not too useful for oracle. Explicit oracle examples are mentioned in the doc. Nice to know, but does this actually work?

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  INET: cjpengel.dbalert_at_xs4all.nl

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).