looking for tool to help consolidate Oracle schemas within Oracle instancesand Oracle instances on AIX servers
- From: J.Polet@xxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 20 Apr 2004 10:20:32 +0200
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
--------------------------------------------------------------------------
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any
disclosure, copying, distribution or taking any action in relation to the
contents of this information is strictly prohibited and may be unlawful.
Neither the sender nor the represented institution are liable for the
correct and complete transmission of the contents of an e-mail, or for its
timely receipt.
--------------------------------------------------------------------------
----------------------------------------------------------------
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:
- » looking for tool to help consolidate Oracle schemas within Oracle instancesand Oracle instances on AIX servers
