Re: What is the best way to estimate capacity?
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: nupendra@xxxxxxxxxxx
- Date: Mon, 17 Oct 2011 23:11:21 +0200
Upendra,
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@xxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
