DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=Kfb8xdfyY4a/0aeDPxs9MMMpKkarIlh6S4vWkGJ6paWsrg761SetST65YAyDImGDN6iUrelDvkpcCxGDPVcPPw8LobFU1evZE/QAbMHw/SfBxlrJR2A7oB4vPLdhGnau2TVj3OBkTdDHIVBucCPLt2ULEXuY3yDYsRQtV7hZMk0=
Message-ID: <de807caa0711211327x150e3168jf0af2f1046b9a206@mail.gmail.com>
Date: Wed, 21 Nov 2007 15:27:48 -0600
From: "Dennis Williams" <oracledba.williams@gmail.com>
To: rjamya@gmail.com
Subject: Re: CPU load per db instance
Cc: "Oracle Discussion List" <oracle-l@freelists.org>
In-Reply-To: <9177895d0711211207m3f024d34ua8fc57aac2b51f33@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_26944_25127116.1195680468284"
References: <9177895d0711211207m3f024d34ua8fc57aac2b51f33@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: oracledba.williams@gmail.com
------=_Part_26944_25127116.1195680468284
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Raj,

A couple of thoughts for you and hopefully someone else has better
suggestions. One question is what is your goal. Are you just wanting a rough
idea for capacity planning or if you are going to bill customers based on
this. If the latter, you'll want a more bulletproof solution whose integrity
you can defend.
   I'm not sure if STATSPACK will help much because it runs within the
Oracle environment. I think you need something at the Solaris level.
    O.S. tools often track usage by O.S. user, so you could install each
Oracle instance in different Unix username, but most of us DBAs consider
that nonstandard. In Solaris 10, you could investigate Zones, but I'm not
sure if Oracle 10g supports Zones yet.
    Solaris 10 includes DTrace and I'm guessing that might be able to do
what you want. It is a very powerful tool for this type of work. But you'll
probably have to ask a forum for Solaris like the Usenet Newsgroup
comp.unix.solaris.
    A simple-minded approach would be to look at your processes associated
with each instance and see if there is anything unique about them, using the
"ps" command. Then you could write a Unix script that would execute ps and
categorize the processes by Oracle instance and sum the CPU load for that
instance. Run that every few minutes as a cron job and accumulate an
estimate of usage over time. Crude but I think doable.

Dennis Williams

------=_Part_26944_25127116.1195680468284
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Raj,<br>&nbsp;</div>
<div>A couple of thoughts for you and hopefully someone else has better suggestions. One question is what is your goal. Are you just wanting a rough idea for capacity planning or if you are going to bill customers based on this. If the latter, you&#39;ll want a more bulletproof solution whose integrity you can defend.
</div>
<div>&nbsp;&nbsp; I&#39;m not sure if STATSPACK will help much because it runs within the Oracle environment. I think you need something at the Solaris level.</div>
<div>&nbsp;&nbsp;&nbsp; O.S. tools often track usage by O.S. user, so you could install each Oracle instance in different Unix username, but most of us DBAs consider that nonstandard. In Solaris 10, you could investigate Zones, but I&#39;m not sure if Oracle 10g supports Zones yet.
</div>
<div>&nbsp;&nbsp;&nbsp; Solaris 10 includes DTrace and I&#39;m guessing that might be able to do what you want. It is a very powerful tool for this type of work. But you&#39;ll probably have to ask a forum for Solaris like the&nbsp;Usenet Newsgroup&nbsp;
comp.unix.solaris.</div>
<div>&nbsp;&nbsp;&nbsp; A simple-minded approach would be to look at your processes associated with each instance and see if there is anything unique about them, using the &quot;ps&quot; command. Then you could write a Unix script that would execute ps and categorize the processes by Oracle instance and sum the CPU load for that instance. Run that every few minutes as a cron job and accumulate&nbsp;an estimate of usage over time.&nbsp;Crude but I think doable.
</div>
<div>&nbsp;</div>
<div>Dennis Williams</div>

------=_Part_26944_25127116.1195680468284--
--
http://www.freelists.org/webpage/oracle-l