Re: AW: Query on Linux 'top' command for oracle user

Well I knew I should have just kept my mouth shut. ;) Do let us know when you 
get the linux version done.

Kerry Osborne
Enkitec
blog: kerryosborne.oracle-guy.com






On Oct 21, 2010, at 8:26 AM, Tanel Poder wrote:

> Note that unfortunately the Cached figure includes the whole pagecache, 
> meaning both filesystem buffer cache and cached mmap()'ed pages - which is 
> how Oracle allocates PGA/UGA memory since 9i (the real-free memory allocation 
> function). And we don't know how much of that "Cached" figure is fileystem 
> cache and how much is mmap()'ed private memory pagecache. 
> 
> Here's a test case, I'm flushing Linux filesystem buffer cache, directory 
> entries (dentries) and inodes, but most of the Cached memory is still there:
> 
> [root@linux03 ~]# grep ^Cached /proc/meminfo ; sync ; echo 3 > 
> /proc/sys/vm/drop_caches ; grep ^Cached /proc/meminfo
> Cached:        2408860 kB
> Cached:        1964056 kB
> 
> I have a script half-ready which can tell you the true picture just like my 
> process memory matrix for Solaris does... The linux version isn't published 
> yet, but the solaris version is here: 
> http://tech.e2sn.com/oracle/performance/unix-performance-tools/process-memory-matrix
> 
> --
> Tanel Poder
> New virtual conference and online seminars!
> http://tech.e2sn.com/virtual-conferences
> http://tech.e2sn.com/oracle-training-seminars
> 
> 
> On Thu, Oct 21, 2010 at 3:47 PM, Kerry Osborne <kerry.osborne@xxxxxxxxxxx> 
> wrote:
> You can also get overall system memory info from /proc/meminfo. Linux wants 
> to suck up most available (free) memory for file system cache, so the free 
> command always reports a pretty low value. Here's a little script that pulls 
> info from /proc/meminfo to report available memory including file system 
> cache. While no where near as sophisticated as Tanel's pmap script for 
> Solaris, it will at least give you an idea how much memory is available on a 
> Linux box without having to add numbers yourself. ;) Note this script was 
> actually written by a guy named Sean Turner who works at Oracle now. I always 
> use the -a parameter.
> 
> 
> #!/bin/ksh
> 
> FREEMEM=`cat /proc/meminfo | grep MemFree: | sed -e 's/  */ /g' | cut -f2 -d' 
> '`
> CACHED=`cat /proc/meminfo | grep Cached: | grep -v SwapCached: | sed -e 's/  
> */ /g' | cut -f2 -d' '`
> TOTALMEM=`cat /proc/meminfo | grep MemTotal: | sed -e 's/  */ /g' | cut -f2 
> -d' '`
> 
> ((FREEMEM=${FREEMEM}/1024))
> ((CACHED=${CACHED}/1024))
> ((TOTALMEM=${TOTALMEM}/1024))
> 
> ((TOTALFREE=${FREEMEM}+${CACHED}))
> ((REALFREE=$TOTALFREE*100))
> ((REALFREEPCT=$REALFREE/$TOTALMEM))
> 
> 
> if [ "$1" = "-a" ]; then
>   echo 'Free Memory:' ${FREEMEM}'M'
>   echo 'Cached Memory:' ${CACHED}'M'
>   echo 'Total Free Memory:' ${TOTALFREE}'M'
>   echo 'Total Memory:' ${TOTALMEM}'M'
>   echo 'Percent Memory Free (including cache):' ${REALFREEPCT}'%'
> else
>   echo 'Percent Memory Free (including cache):' ${REALFREEPCT}'%'
> fi
> 
> return $REALFREEPCT
> 
> Kerry Osborne
> Enkitec
> blog: kerryosborne.oracle-guy.com
> 
> 
> 
> 
> 
> 
> On Oct 21, 2010, at 4:47 AM, Petr Novak wrote:
> 
>> Hi Sreejith,
>> 
>> read Tanels article
>> 
>> http://tech.e2sn.com/oracle/performance/unix-performance-tools/process-memory-matrix
>> 
>> 
>> Best Regards,
>> Petr
>> 
>> 
>> -----Ursprüngliche Nachricht-----
>> Von: oracle-l-bounce@xxxxxxxxxxxxx im Auftrag von Sreejith S Nair
>> Gesendet: Do 21.10.2010 11:41
>> An: oracle-l@xxxxxxxxxxxxx
>> Betreff: Query on Linux 'top' command for oracle user
>> 
>> This is the output of 'top' command in one of my linux server hosting One
>> Oracle instance with 600MB SGA and 400MB PGA. One one instance is up in
>> this server.
>> top - 14:36:37 up 4:26, 3 users, load average: 0.05, 0.11, 0.28
>> Tasks: 124 total, 1 running, 123 sleeping, 0 stopped, 0 zombie
>> Cpu(s): 0.2% us, 0.1% sy, 0.0% ni, 66.6% id, 33.1% wa, 0.0% hi, 0.0% si
>> Mem: 12299332k total, 2569836k used, 9729496k free, 61288k buffers
>> Swap: 20972816k total, 0k used, 20972816k free, 2274852k cached
>> 
>> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
>> 6345 oracle 16 0 37132 1752 1172 S 0.0 0.0 0:00.08 sshd
>> 6346 oracle 16 0 54004 1536 1208 S 0.0 0.0 0:00.02 bash
>> 6423 oracle 16 0 45376 10m 6228 S 0.0 0.1 0:00.25 tnslsnr
>> 6471 oracle 16 0 740m 17m 13m S 0.0 0.1 0:00.02 oracle
>> 6473 oracle 16 0 739m 15m 12m S 0.0 0.1 0:00.01 oracle
>> 6475 oracle 16 0 739m 32m 29m S 0.0 0.3 0:00.07 oracle
>> 6477 oracle 16 0 742m 50m 44m S 0.0 0.4 0:00.27 oracle
>> 6479 oracle 16 0 754m 23m 19m S 0.0 0.2 0:00.43 oracle
>> 6481 oracle 16 0 739m 24m 20m S 0.0 0.2 0:00.61 oracle
>> 6483 oracle 16 0 740m 88m 83m S 0.0 0.7 0:00.71 oracle
>> 6485 oracle 16 0 739m 22m 19m S 0.0 0.2 0:00.01 oracle
>> 6487 oracle 16 0 740m 30m 25m S 0.0 0.3 0:00.15 oracle
>> 6489 oracle 16 0 741m 55m 48m S 0.0 0.5 0:00.29 oracle
>> 6491 oracle 16 0 739m 24m 20m S 0.0 0.2 0:00.01 oracle
>> 6493 oracle 16 0 739m 15m 11m S 0.0 0.1 0:00.01 oracle
>> 6495 oracle 16 0 739m 14m 11m S 0.0 0.1 0:00.00 oracle
>> 6622 oracle 16 0 739m 16m 13m S 0.0 0.1 0:00.00 oracle
>> 6626 oracle 16 0 740m 79m 74m S 0.0 0.7 0:01.95 oracle
>> 6636 oracle 16 0 740m 28m 23m S 0.0 0.2 0:00.06 oracle
>> 6638 oracle 16 0 739m 16m 12m S 0.0 0.1 0:00.01 oracle
>> 6846 oracle 16 0 739m 19m 16m S 0.0 0.2 0:00.02 oracle
>> 6848 oracle 16 0 739m 24m 21m S 0.0 0.2 0:00.04 oracle
>> 6850 oracle 16 0 739m 19m 16m S 0.0 0.2 0:00.02 oracle
>> 6852 oracle 16 0 739m 19m 16m S 0.0 0.2 0:00.01 oracle
>> 6854 oracle 16 0 739m 30m 26m S 0.0 0.3 0:00.12 oracle
>> 6856 oracle 15 0 739m 28m 24m S 0.0 0.2 0:00.18 oracle
>> 6858 oracle 15 0 740m 40m 35m S 0.0 0.3 0:06.39 oracle
>> 6862 oracle 16 0 739m 32m 28m S 0.0 0.3 0:02.25 oracle
>> 6864 oracle 16 0 739m 19m 16m S 0.0 0.2 0:00.02 oracle
>> 6866 oracle 16 0 739m 19m 16m S 0.0 0.2 0:00.03 oracle
>> 6868 oracle 16 0 739m 19m 16m S 0.0 0.2 0:00.02 oracle
>> 7480 oracle 15 0 37264 1668 1092 S 0.0 0.0 0:00.15 sshd
>> 7481 oracle 15 0 54004 1528 1196 S 0.0 0.0 0:00.05 bash
>> 10333 oracle 16 0 739m 20m 16m S 0.0 0.2 0:00.00 oracle
>> 10337 oracle 15 0 6168 1080 768 R 0.0 0.0 0:00.00 top
>> 
>> Total RAM as seen from top command is 12G.
>> 2569836 - Total RAM which is being used currently .
>> 
>> How can I see the total RAM used by all Oracle Processes running in this
>> server. The server is Linux X86 64 Bit. Can I sum up the values under
>> 'VIRT' column of 'top' command to see the total RAM used ?
>> 
>> Is there a way to see the total *RAM and CPU u*sed by Oracle from top ?
>> 'VIRT' is the virtual memory - In what way is this related to the figure
>> above, which is the physical memory (RAM) ?
>> 
>> Thanks in Advance
>> SSN
>> 
>> Thank You,
>> 
>> Kind Regards,
>> Sreejith Nair
>> 
>> 
>> 
>> 
>> 
>> 
>> DISCLAIMER:
>> 
>> "The information in this e-mail and any attachment is intended only for
>> the person to whom it is addressed and may contain confidential and/or
>> privileged material. If you have received this e-mail in error, kindly
>> contact the sender and destroy all copies of the original communication.
>> IBS makes no warranty, express or implied, nor guarantees the accuracy,
>> adequacy or completeness of the information contained in this email or any
>> attachment and is not liable for any errors, defects, omissions, viruses
>> or for resultant loss or damage, if any, direct or indirect."
>> 
>> 
>> 
>> 
>> 
>> 
> 
>

Other related posts: