RE: looking for tool to help consolidate Oracle schemas within Oracle instances and Oracle instances on AIX servers
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Apr 2004 09:42:42 -0400
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@xxxxxxxxx [mailto:J.Polet@xxxxxxxxx]
Sent: Tuesday, April 20, 2004 4:21 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
