Re: What is the best way to estimate capacity?

you can check for "CPU Time" events in AWR and even in statspack. These data might be just imprecise, but at least it's a starting point. In recent versions you can also use V$SYSMETRIC_HISTORY or DBA_HIST_SYSMETRIC_SUMMARY to compare the number of "CPU Time" to the system load.

hopefully this is a start of some breadcrumbs for you,  Martin

On Thu, Oct 13, 2011 at 23:12, Upendra N <nupendra_at_hotmail.com> wrote:
>
>
>
>
> 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

--
http://www.freelists.org/webpage/oracle-l