Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: CPU usage in a multi database environment

Re: CPU usage in a multi database environment

From: Orlando L <oralrnr_at_gmail.com>
Date: Tue, 21 Nov 2006 22:08:28 -0800
Message-ID: <4e0c9d990611212208y6d205712j763b88fdcf999b32@mail.gmail.com>


I am using SunOS 5.8.

On 11/21/06, Alex Gorbachev <gorbyx_at_gmail.com> wrote:
>
> If you want to see it in top press "c". Not that it's the most
> reliable method but since you mentioned it...
> You are on Linux. Right?
>
> On 11/21/06, Orlando L <oralrnr_at_gmail.com> wrote:
> > Hi all,
> >
> >
> > I have a server with 6 Oracle databases running. How do I find out which
> > processes are consuming the CPU?
> >
> > top shows something like this which does not help me:
> >
> > PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
> > 16475 oracle 11 26 2 698M 660M sleep 1:34 8.97% oracle
> > 16477 oracle 11 46 2 697M 659M sleep 1:56 7.96% oracle
> > 7605 oracle 11 46 2 886M 850M cpu10 11:48 6.13% oracle
> > 1767 oracle 15 58 0 898M 842M sleep 184:54 0.66% oracle
> > 14363 oracle 1 59 2 885M 841M sleep 448:25 0.28% oracle
> > 7603 oracle 4 52 2 15M 8848K sleep 0:19 0.27% sqlplus
> >
> >
> > Orlando.
> >
>
>
> --
> Best regards,
> Alex Gorbachev
>
> The Pythian Group
> Sr. Oracle DBA
>
> http://www.pythian.com/blogs/author/alex/
> http://blog.oracloid.com
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 22 2006 - 00:08:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US