What is the best way to estimate capacity?

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
                                               

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 13 2011 - 16:12:45 CDT