RE: looking for tool to help consolidate Oracle schemas within Oracle instances and Oracle instances on AIX servers

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Tue, 20 Apr 2004 09:42:42 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6506D98B@25exch1.vicorpower.vicr.com>

Jaco,

        Unless your application forces everyone using data from a particular = schema to log on as that schema Resource Manager is not going to help = you. Resource Manager is based on who you logged onto the database as. = Wish it worked otherwise since it could then help us with PeopleSoft. = But since everyone using PeopleSoft connects to the database as the = PeopleSoft owner, we're stuck.

        Also, most of the tools in this area today set an upper limit which = under normal circumstances a process/user should not exceed. Problem is = that when a user/process starts up these tools acquire a snapshot of how = the system/instance is loaded & then allow the user/process to run with = that. Therefore, even though you don't want a specific user to exceed = 25% utilization of the system, they will on occasion exceed that by a = significant amount & the software is somewhat slow at adjusting them = back down, because it may well be just a "spurt" that goes away by = itself. Therefore adjust your expectations accordingly.

        OEM's Performance pack will provide you insight into how much resources = a schema is using from a particular instance. IBM should have some = performance management stuff, or else you can acquire it from CA(yeah, I = know bad thing to say). You want to measure instances against each = other, and schema's against each other within an instance. Don't try = crossing schema's between instances, you'll get only odd results, mostly = bad. (BTDT)

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: J.Polet_at_Robeco.nl [mailto:J.Polet_at_Robeco.nl] Sent: Tuesday, April 20, 2004 4:21 AM
To: oracle-l_at_freelists.org
Subject: looking for tool to help consolidate Oracle schemas within Oracle instances and Oracle instances on AIX servers

Hi all,

I am currently working on a consolidation project. Within this project we want to consolidate Oracle schemas within Oracle 8.1.7.4/ 10g instances and Oracle instances on AIX 5.2 servers.

We see 3 potential problems:
1. How do we prevent instances and schema's influencing each others performance?
2. How do we determine which schemas can be consolidated within the same instance from a resource usage point of view? 3. How do we determine which instances can be consolidated on the same server from a resource usage point of view?

To address our first problem we are looking at the Oracle Resource = Manager
for controlling the resource usage of schemas within the same instance = and
AIX Workload Manager to control resource usage of instances on the same server.

For our second and third problem we want to create a shortlist of 3 (combination of) tools to evaluate which should be able to:
- Measure the usage of instance resources like buffer cache, redo/undo
blocks, open cursors etc. on a schema level.
- Measure the available instance resources within an instance

• Measure the usage of server resources (CPU, Memory, Disk IO, Network = IO) on a schema level and on an instance level.
• Measure the available server resources within a server

Does anyone has an idea of which (combination of) tools I should put on this shortlist?

Thanks... Jaco

 =

-------------------------------------------------------------------------=

-=20
 The information contained in this communication is confidential and may = be=20
 legally privileged. It is intended solely for the use of the individual = or=20
 entity to whom it is addressed and others authorised to receive it. If = you=20
 are not the intended recipient you are hereby notified that any =   =20
 disclosure, copying, distribution or taking any action in relation to = the =20
 contents of this information is strictly prohibited and may be = unlawful. =20
 Neither the sender nor the represented institution are liable for the =   =20
 correct and complete transmission of the contents of an e-mail, or for = its=20

 timely receipt.                                                         =

  =20
 =

-------------------------------------------------------------------------=

-=20

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Apr 20 2004 - 08:48:05 CDT