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