Login or Register to Ask a Question and Join Our Community


Solaris

Oracle memory usage on Solaris box

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Solaris Oracle memory usage on Solaris box
# 15  
Old 09-30-2010
Code:
root@sunfire130 # echo "::memstat" | mdb -k
Page Summary                Pages                MB  %Tot
------------     ----------------  ----------------  ----
Kernel                     572519              4472   14%
Anon                      3087015             24117   75%
Exec and libs               64314               502    2%
Page cache                   9661                75    0%
Free (cachelist)           340233              2658    8%
Free (freelist)             28226               220    1%

Total                     4101968             32046
Physical                  4096728             32005

Code:
sh memory.sh
process: -csh
                shared: 0 KB
                tot private: 632 KB
process: asm_lms0_+ASM2
                shared: 126984 KB
                tot private: 12448 KB
process: asm_dbw0_+ASM2
                shared: 126984 KB
                tot private: 2488 KB
process: asm_lmd0_+ASM2
                shared: 126984 KB
                tot private: 14040 KB
process: xargs
                shared: 0 KB
                tot private: 120 KB
process: asm_lck0_+ASM2
                shared: 126984 KB
                tot private: 3136 KB
process: asm_gmon_+ASM2
                shared: 126984 KB
                tot private: 3648 KB
process: asm_pmon_+ASM2
                shared: 126984 KB
                tot private: 2328 KB
process: sqlplus
                shared: 0 KB
                tot private: 3320 KB
process: asm_mman_+ASM2
                shared: 126984 KB
                tot private: 2024 KB
process: /usr/lib/ssh/sshd
                shared: 0 KB
                tot private: 552 KB
process: sh
                shared: 0 KB
                tot private: 152 KB
process: oracle
                shared: 126984 KB
                tot private: 10551136 KB
process: nawk
                shared: 0 KB
                tot private: 392 KB
process: asm_lmon_+ASM2
                shared: 126984 KB
                tot private: 4320 KB
process: asm_o000_+ASM2
                shared: 126984 KB
                tot private: 832 KB
process: asm_ckpt_+ASM2
                shared: 126984 KB
                tot private: 1728 KB
process: asm_psp0_+ASM2
                shared: 126984 KB
                tot private: 1192 KB
process: asm_rbal_+ASM2
                shared: 126984 KB
                tot private: 2880 KB
process: asm_lgwr_+ASM2
                shared: 126984 KB
                tot private: 2280 KB
process: asm_smon_+ASM2
                shared: 126984 KB
                tot private: 1696 KB
process: asm_diag_+ASM2
                shared: 126984 KB
                tot private: 2896 KB
process: /usr/bin/ssh
                shared: 0 KB
                tot private: 82136 KB

# 16  
Old 09-30-2010
Thanks.
Could you please post the output of the following modified command:
Code:
ps -uoracle -opid= |
  xargs 2>/dev/null pmap -x |
    nawk 'END {
      for (p in priv) 
        printf "process: %s\n\t\tshared: %d KB\n\t\ttot private: %d KB\n", \
          p, shm[p], priv[p]        
      }
    /^[0-9]*:/ { 
      if (/ora/) {
        proc = "oracle"
        next
        }
      if (/asm/)    
        proc = "asm"
        next        
      }
     /total/ {  
      $NF == "-" || shm[proc] = $NF
        priv[proc] += $5 
      }'

And this one:

Code:
ipcs -a



---------- Post updated at 01:24 PM ---------- Previous update was at 01:17 PM ----------

Just a quick recap:
the general memory drill down is clear:

Code:
Page Summary                Pages                MB  %Tot
------------     ----------------  ----------------  ----
Kernel                     572519              4472   14%
Anon                      3087015             24117   75%
Exec and libs               64314               502    2%
Page cache                   9661                75    0%
Free (cachelist)           340233              2658    8%
Free (freelist)             28226               220    1%

Total                     4101968             32046
Physical                  4096728             32005

We have:

- 14% of memory used by the kernel
- 2% executables and libraries
- ~ 9% - free memory

Now we want to know where and how the remaining 75%/24GB of memory are used.
# 17  
Old 09-30-2010
Code:
 ipcs -a
IPC status from <running system> as of Thursday September 30 12:48:07 GMT 2010
T         ID      KEY        MODE        OWNER    GROUP  CREATOR    CGROUP CBYTES  QNUM QBYTES LSPID LRPID   STIME    RTIME    CTIME
Message Queues:
q          0   0x61037083 --rw-------     root     root     root      root      0     0  65536  1013  1144 12:48:06 12:48:07  5:37:46
T         ID      KEY        MODE        OWNER    GROUP  CREATOR    CGROUP NATTCH      SEGSZ  CPID  LPID   ATIME    DTIME    CTIME
Shared Memory:
m         16   0xb2d23620 --rw-r-----   oracle oinstall   oracle  oinstall   2493 5251284992 14099 25818 12:47:53 12:47:53  5:48:42
m          1   0x2fe9b7f0 --rw-r-----   oracle oinstall   oracle  oinstall     18  130031616  3446 24816 12:47:14 12:47:15  5:39:26
T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP NSEMS   OTIME    CTIME
Semaphores:
s         65   0x9ec866c4 --ra-r-----   oracle oinstall   oracle oinstall   312  5:49:02  5:48:44
s         64   0x9ec866c3 --ra-r-----   oracle oinstall   oracle oinstall   312 no-entry  5:48:44
s         63   0x9ec866c2 --ra-r-----   oracle oinstall   oracle oinstall   312 no-entry  5:48:44
s         62   0x9ec866c1 --ra-r-----   oracle oinstall   oracle oinstall   312 no-entry  5:48:44
s         61   0x9ec866c0 --ra-r-----   oracle oinstall   oracle oinstall   312 no-entry  5:48:44
s         60   0x9ec866bf --ra-r-----   oracle oinstall   oracle oinstall   312 no-entry  5:48:44
s         59   0x9ec866be --ra-r-----   oracle oinstall   oracle oinstall   312 no-entry  5:48:44
s         58   0x9ec866bd --ra-r-----   oracle oinstall   oracle oinstall   312  8:27:40  5:48:44
s         57   0x9ec866bc --ra-r-----   oracle oinstall   oracle oinstall   312 12:48:07  5:48:44
s         56   0x9ec866bb --ra-r-----   oracle oinstall   oracle oinstall   312 12:48:07  5:48:44
s         55   0x9ec866ba --ra-r-----   oracle oinstall   oracle oinstall   312 12:48:07  5:48:44
s         54   0x9ec866b9 --ra-r-----   oracle oinstall   oracle oinstall   312 12:48:07  5:48:44
s         53   0x9ec866b8 --ra-r-----   oracle oinstall   oracle oinstall   312 12:48:07  5:48:44
s         52   0x9ec866b7 --ra-r-----   oracle oinstall   oracle oinstall   312 12:48:07  5:48:44
s         51   0x9ec866b6 --ra-r-----   oracle oinstall   oracle oinstall   312 12:48:07  5:48:44
s         50   0x9ec866b5 --ra-r-----   oracle oinstall   oracle oinstall   312 12:48:07  5:48:44
s         49   0x9ec866b4 --ra-r-----   oracle oinstall   oracle oinstall   312 12:48:07  5:48:44
s          5   0xe7e53e34 --ra-r-----   oracle oinstall   oracle oinstall    44 12:47:38  5:39:26
s          0   0x710371cd --ra-ra-ra-     root     root     root     root     1 12:38:11  5:37:38

Code:
sh memory.sh
process: oracle
                shared: 126984 KB
                tot private: 9954600 KB
process: asm
                shared: 126984 KB
                tot private: 57544 KB

# 18  
Old 09-30-2010
OK,
now I see circa 15GB (10 private, 5 shared) for Oracle (the script reports wrong result for the shared memory for the oracle processes, of course).
Could you confirm that the free memory is still 2.5GB (vmstat -S 2 10)?

If that's the case, you should check the memory used by other users too (with root ps -eopid= ...).

---------- Post updated at 04:22 PM ---------- Previous update was at 04:15 PM ----------

I understand that actually now we are where we were when you first asked the question ...

I saw you posted the same question on the official Oracle forums, did you get some useful answers there (I cannot find the thread right now)?

---------- Post updated at 04:23 PM ---------- Previous update was at 04:22 PM ----------

Is the number of clusterware processes still so high?

---------- Post updated at 04:34 PM ---------- Previous update was at 04:23 PM ----------

And another one, could you confirm that the value of sga_max_size (not sga_target) is 5GB?
# 19  
Old 09-30-2010
Code:
vmstat -S 2 10
 kthr      memory            page            disk          faults      cpu
 r b w   swap  free  si  so pi po fr de sr m0 m1 m3 m4   in   sy   cs us sy id
 0 0 0 5657056 4946968 0  0 179402309854 203 201 0 0 1 3 -0 -0 16487 30555 15737 4 3 94
 0 0 0 3713728 3290776 0  0 6494660262341 0 0 0 0 0 0 0 0 15368 25258 14641 5 2 93
 0 0 0 3709600 3285520 0  0 6246461904991 47 47 0 0 0 0 0 0 16429 114358 15839 5 2 92
 0 0 0 3713600 3286216 0  0 6205564249761 0 0 0 0 0 0 0 0 16672 16567 15848 4 2 93
 0 0 0 3713656 3283752 0  0 6188747002471 0 0 0 0 0 0 0 0 16082 14973 15388 4 2 94
 1 0 0 3711984 3279496 0  0 5920576609748 8 8 0 0 0 0 0 0 15907 15596 15172 5 2 93
 0 0 0 3683256 3279104 0  0 5778945759465 145 106 0 0 0 0 0 0 15537 46346 14897 5 2 94
 0 0 0 3699112 3264800 0  0 6081406690378 98 98 0 0 0 0 0 0 17116 183348 16591 6 4 90
 0 0 0 3712864 3281904 0  0 5933765549732 129 129 0 0 0 0 0 0 16671 68771 16118 6 4 90
 1 0 0 3713648 3283944 0  0 9696136469918 0 0 0 0 0 0 0 0 15815 24052 15085 5 2 93

Clusterware processes memory usage is still high. Think so this is some bug as I wouldn't have expected cluster verify processes to be running after the installation.

I didn't receive any help from oracle forums as expected as this is more Unix related question though very much tied up to Oracle.
# 20  
Old 09-30-2010
Could you also post the output of ps -falde, thanks!
The entire output.
# 21  
Old 09-30-2010
edit by scottn: moved ps output (1558 lines) to .txt attachment
ps_ora.txt (172.0 KB) 
Last edited by Scott; 12-08-2010 at 02:45 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

How to find out the memory usage in Solaris?

Hi All, In one of the solaris box aslert got triggered as ... (Used_Real_Mem_Pct=93.0 Used_Swap_Space_Pct=75.0 )] when i see the usage by vmstat and sar i am not able to relate the alert with the free memory and swap memory please help to understand the vmstat output as below.. kthr ... (4 Replies)
Discussion started by: Riverstone
4 Replies

2. Solaris

Solaris memory usage

One of my Solaris Unix server has total RAM 128G . top & vmstat command shows free memory is 86G and usage is 42G. ps -eo pid,rss,commshows memory usage by process. when i sum all the memory usage by the process, it shows 1.9TB as shown below. $ ps -eo pid,pmem,vsz,rss,comm | sort -rnk2 |... (5 Replies)
Discussion started by: baladelaware73
5 Replies

3. Solaris

Solaris Memory usage by oracle, java

Hello Gurus, In Office, I have unix Solaris Server. Oracle and Java is installed on Solaris Server. Oracle when starts then oracle loads SGA, PGA memory and graps solaris server memory. In the same manner java and other applications grabs memory for them. I want memory distribution of... (4 Replies)
Discussion started by: get_chandrakant
4 Replies

4. Solaris

Memory usage in a Solaris Container

Hi All, We have a server with Solaris 10 installed. The total memory of the server is 64GB. In order to check the memory info of the server I use "top" utility that gives me total and free memory in real-time. I have also installed a Sun container (non-global zone) on top of parent operating... (4 Replies)
Discussion started by: Slayer
4 Replies

5. Solaris

Memory usage in Solaris - memory not freed?

Hi, I'm running a multi-process software system on a Solaris 8 machine. When I monitor the memory usage, I see that the free memory is dropping rapidly, but I can't detect a process that uses this memory. I'm using "top" to get the free memory and the memory usage of processes. Thanks. (3 Replies)
Discussion started by: gewurtz
3 Replies

6. HP-UX

how can I find cpu usage memory usage swap usage and logical volume usage

how can I find cpu usage memory usage swap usage and I want to know CPU usage above X% and contiue Y times and memory usage above X % and contiue Y times my final destination is monitor process logical volume usage above X % and number of Logical voluage above can I not to... (3 Replies)
Discussion started by: alert0919
3 Replies

7. UNIX for Dummies Questions & Answers

memory usage : kernel, oracle, other users

Hello, I'm looking for a command or script that could permit me to know what is memory usage group by HP-UX kernel, oracle processes and other users (specific software). A command like 'top' but for all processes and not only for 12 max could be very useful Thanks in advance (4 Replies)
Discussion started by: thierryUX
4 Replies

8. UNIX for Dummies Questions & Answers

Comman/Tool to check memory leak in solaris box

Hello Guys, Please let me know about commands or tools that are available to check memory leak in solaris box. Thanks in Advance (1 Reply)
Discussion started by: rajeshlbryan
1 Replies

9. Solaris

oracle process and LWP on solaris 8 box

Hi all, Without oracle tunning I understand that oracle processes always run on a single CPU at a time (the prstat output always show 1 CPU number) even on multi-processor hardware. Is it correct? Regards, (1 Reply)
Discussion started by: solea
1 Replies

10. Filesystems, Disks and Memory

Memory usage in the box

Hello: Environment is: Oracle 817 on IBM RS/6000 AIX 433 I have 4GB RAM on the box and Page/Swap is about the same. Presently I am using close to 1GB of RAM towards 5 instances of ORACLE production environments. How can I know, how much of memory/RAM is used for : Oracle Processes , I... (2 Replies)
Discussion started by: ST2000
2 Replies
Login or Register to Ask a Question