What is the best way to estimate capacity?

  • From: Upendra N <nupendra@xxxxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 13 Oct 2011 17:12:45 -0400




Hello all,
If a server is running multiple databases (ranges from 8.1.7.4 to 10.2). Is 
there a way to estimate the CPU capacity that are used by each of the database 
which will relate to the OS system load?
We do have AWR (tuning/diagnostic packs) for 10.2 databases, but we may have to 
rely on other methods for 8i databases.

I'm trying to arrive at something like this:
Database-1 = 30%
Database-2 = 20%
Database-3 = 10%
Database-4 = 40% 

The hardware platform is Sun Sparc Solaris 9.

I'm trying to relocate a few databases to newer platform. With the move I'd 
like to recoup some of the Oracle licenses by reducing CPU capacity (turning 
the CPUs off or physically pull them out ) on the legacy servers.
Your suggestions are greatly appreciated.

Thanks
-Upendra
                                          
--
//www.freelists.org/webpage/oracle-l


Other related posts: