Re: CPU usage in a multi database environment
- From: "Orlando L" <oralrnr@xxxxxxxxx>
- To: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- Date: Tue, 21 Nov 2006 22:08:28 -0800
I am using SunOS 5.8.
On 11/21/06, Alex Gorbachev <gorbyx@xxxxxxxxx> 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@xxxxxxxxx> 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
- Follow-Ups:
- Re: CPU usage in a multi database environment
- From: Remigiusz Sokołowski
- References:
- CPU usage in a multi database environment
- From: Orlando L
- Re: CPU usage in a multi database environment
- From: Alex Gorbachev
Other related posts:
- » CPU usage in a multi database environment
- » Re: CPU usage in a multi database environment
- » Re: CPU usage in a multi database environment
- » Re: CPU usage in a multi database environment
- » RE: CPU usage in a multi database environment
- » Re: CPU usage in a multi database environment
- » Re: CPU usage in a multi database environment
- » Re: CPU usage in a multi database environment
- » Re: CPU usage in a multi database environment
- » RE: CPU usage in a multi database environment
- » Re: CPU usage in a multi database environment
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@xxxxxxxxx> 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
- Re: CPU usage in a multi database environment
- From: Remigiusz Sokołowski
- CPU usage in a multi database environment
- From: Orlando L
- Re: CPU usage in a multi database environment
- From: Alex Gorbachev