Sponsored Content
Operating Systems Solaris Oracle memory usage on Solaris box Post 302457947 by prabumohan on Wednesday 29th of September 2010 06:43:23 AM
Old 09-29-2010
Quote:
Could you provide the exact error code and message (ORA- ...)?
ORA-04030: out of process memory when trying to allocate 82456 bytes (pga heap,control file i/o buffer)

Code:
SQL> !vmstat -S
 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 5864088 5114360 0  0 114122802779 166 164 0 0 1 3 -0 -0 16470 30371 15706 4 3 94

Number of sessions

Code:
SQL> set pages 200 lines 132
select server, count(1) from v$session
group by server;SQL>   2

SERVER      COUNT(1)
--------- ----------
DEDICATED       2538

PGA usage

Code:
NAME                                          VALUE UNIT
---------------------------------------- ---------- ------------
aggregate PGA target parameter           2097152000 bytes
aggregate PGA auto target                 131072000 bytes
global memory bound                       209715200 bytes
total PGA inuse                          3829838848 bytes
total PGA allocated                      6324478976 bytes
maximum PGA allocated                    6921444352 bytes
total freeable PGA memory                 641400832 bytes
process count                                  2561
max processes count                            2850
PGA memory freed back to OS              7.7713E+10 bytes
total PGA used for auto workareas           2102272 bytes
maximum PGA used for auto workareas       150141952 bytes
total PGA used for manual workareas               0 bytes
maximum PGA used for manual workareas        537600 bytes
over allocation count                        400469
bytes processed                          1.9377E+11 bytes
extra bytes read/written                 6706253824 bytes
cache hit percentage                          96.65 percent
recompute count (total)                      403688

19 rows selected.

Memory usage by java processes and ssh processes

Code:
ps -eorss,args | nawk 'END { print s/1024, "MB" } /ssh/ { s += $1 }'
658.383 MB
ps -eorss,args | nawk 'END { print s/1024, "MB" } /java/ { s += $1 }'
5800.34 MB

I did try checking the rest of the processes other than oracle db, asm, ssh, java and external connections
Code:
ps -eorss,args | grep -v oracleavt31 | grep -v java | grep -v PasswordAuthentication=no | grep -v oracleavt31 | grep -v asm | grep -v ora_ | nawk 'END { print s/1024, "MB" }  { s += $1 }'
1281.53 MB

So Oracle SGA+PGA comes to around 11G, ASM sga settings is 300M, ssh memory usage is 658M, java memory usage is 5.8G, other process memory is around 1.3G. So in total it comes to around 19G but still I am missing 5G of memory, not sure how this is being utilized?

prstat -a -s rss shows oracle user being using 24G of memory.

Also for a few processes the complete command is getting trimmed for example
Code:
ps -ef | grep PasswordAuthentication
oracle  2230  2190   0   Sep 16 ?           0:00 /usr/bin/ssh -o FallBackToRsh=no -o PasswordAuthentication=no -o StrictHostKeyC

and this is the same case when I check java processes too
Is there any way I can get to know the complete OS command being used without getting trimmed?

Last edited by prabumohan; 09-29-2010 at 07:49 AM..
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
All times are GMT -4. The time now is 04:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy