RE: What is the best way to estimate capacity?
- From: Upendra N <nupendra@xxxxxxxxxxx>
- To: <martin.a.berger@xxxxxxxxx>
- Date: Mon, 17 Oct 2011 17:28:33 -0400
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 126.96.36.199 and the rest are on 9i. I found that 188.8.131.52 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@xxxxxxxxx > Date: Mon, 17 Oct 2011 23:11:21 +0200 > Subject: Re: What is the best way to estimate capacity? > To: nupendra@xxxxxxxxxxx > CC: oracle-l@xxxxxxxxxxxxx > > 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 184.108.40.206 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