RE: What is the best way to estimate capacity?
Date: Mon, 17 Oct 2011 17:28:33 -0400
Message-ID: <BLU129-W6CDD9B3DAC5513174CAB0D8E40_at_phx.gbl>
Thanks Martin. "CPU Time" is certainly a good place to start...
This box is running 15 database instances (with varying workloads), and a majority of them are on 8.1.7.4 and the rest are on 9i. I found that 8.1.7.4 database could be configured to work with 10g Grid control. I am thinking of registering them in Grid control and gather history at the database level.. hopefully it provides some useful information.
Thanks a bunch
-Upendra
> From: martin.a.berger_at_gmail.com
> Date: Mon, 17 Oct 2011 23:11:21 +0200
> Subject: Re: What is the best way to estimate capacity?
> To: nupendra_at_hotmail.com
> CC: oracle-l_at_freelists.org
>
> 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_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-lReceived on Mon Oct 17 2011 - 16:28:33 CDT