Re: Finding which DB is consuming max resources

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 15 Aug 2003 16:50:57 -0700
Message-ID: <Cle%a.410$kP.110@fed1read03>

Michael Lackey wrote:
> "Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:<3f38a674$0$10355$afc38c87_at_news.optusnet.com.au>...
>

>>"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F37C0D4.31D5FDBF_at_remove_spam.peasland.com...
>>
>>
>>
>>>Sign on to each of your 30 instances (or is it 25? Your posts conflict
>>>with each other) with SQL*Plus and issue SHOW SGA. This will give you
>>>the memory for the *shared* portion of the instance. That's a start...
>>>
>>
>>
>>don't worry.  there was one the other day
>>somewhere else asking for how to run 100 instances
>>in the same box.  and he got meaningful replies...

>
>
> Had this happen to me once (beyond my control, will describe why at
> the end). What I would do is run a top command and get the top 10
> user spids for oracle and then pass those to a script that looged into
> each instance and looked for the spid in v$sessions. Usually just one
> or two causing the heavy load.

You don't have to go into any DB to determine to which instance the PID is (ab)using.

$ ps -ef | grep {PID}
part of the output will include the SID to which the process is attached. Received on Fri Aug 15 2003 - 18:50:57 CDT