Re: High Memory Usage

  • From: Adric Norris <landstander668@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 31 Aug 2011 11:39:33 -0500

It's been awhile, so it might have been a Solaris 8 box.  I didn't think
this behaviour had changed under Solaris 10, but could certainly be
mistaken.

On Wed, Aug 31, 2011 at 11:07, LS Cheng <exriscer@xxxxxxxxx> wrote:

> what version of solaris?
>
> this prstat -a output from our server which has 192 GB physical memory
>
>  NPROC USERNAME  SWAP   RSS MEMORY      TIME  CPU
>   1420 rac10gr4   84G   80G    42% 287:44:04  15%
>
> ps -ef|grep rac10gr4|wc -l
>     1423
>
> it takes into consideration shared memory
>
>
> On Wed, Aug 31, 2011 at 3:42 PM, Adric Norris <landstander668@xxxxxxxxx>wrote:
>
>> On Wed, Aug 31, 2011 at 02:23, LS Cheng <exriscer@xxxxxxxxx> wrote:
>>
>>> since its solaris you could try run prstat -a, this will show you the
>>> memory consumed by each OS user
>>>
>>
>> That brings back some fun memories. :)  I once had a SysAdmin complain
>> that Oracle was using 100% of the memory on a Sun box, which was equipped
>> with 64 GB of physical memory and configured for 8 GB of swap space.  The
>> "prstat -a" output, which he helpfully included in his email, clearly showed
>> Oracle consuming 1.5 TB of memory.
>>
>> Needless to say, that command has absolutely no knowledge of shared
>> memory.
>>
>>
-- 
"I'm too sexy for my code." -Awk Sed Fred

Other related posts: