Oracle memory usage on Solaris box


 
Thread Tools Search this Thread
Operating Systems Solaris Oracle memory usage on Solaris box
# 29  
Old 12-08-2010
what gives :

at OS level
Code:
ipc -m | grep ora

at DB level (by the way, i'm not sure if Oracle RAC have these views but if so, let's have a look):
Code:
show sga
show parameter sga
show db_cache
select * from gv$resource_limit
select * from v$pgastat
select * from v$db_cache_advice
select * from v$pga_target_advice

Do you use directio ?
Do you use automatic SGA and PGA management ?
What type of file system you have ?

Are you in dedicated server mode or shared server mode ?
(it will determines whether the UGA will be located in PGA or SGA ... at least for standard Oracle DB, i'm not sure how Oracle RAC differs from the "standars" oracle database)

By the way, at the end of last year, we encountered some problem with Solaris memory leak that week after week made the solaris kernel use up to 20% of the RAM (::memstat in crontab logged the evolution ... and .... after reboot : decrease to 2% of the RAM).
Updating to last kernel patch level fixed that issue.

Maybe it doesn't have anything to do with your problem, but it still can give some ideas.

By the way, the ORA- error you got demonstrate an obvious memory undersizing just as Radoulov suggest.

---------- Post updated at 07:24 PM ---------- Previous update was at 07:14 PM ----------

I add bonus technical information that may be of interest for Oracle DBA guys (many people talk about directio without knowing what is behind):

Extract from
: Re: direct reads and writes on Solaris - oracle-l - FreeLists
-------------------------------------------------------------------------------------
A couple of explanations. First, the main reason to do directio is to get
around the Posix single-writer lock. This lock is a mechanism that prevents
2 processes from writing to the same file at the same time, mainly to prevent
them from both trying to write the same block and having unpredictable results.

Since Oracle is already handling the coordination of writes, this lock is not
needed. But the filesystems and OS enforce it automatically. On larger systems
this can cause contention, since many processes may want to write to the same
Oracle datafile at the same time and will be forced to be single-threaded(*).

So methods were introduced to get around those semantics. The 4 that work on
Solaris are using raw devices directly, UFS with directio (either through
filesystemio_options = setall or the forcedirect mount option), VxFS(**) with QIO
or ODM and QFS with samaio. Note that VxFS with mincache=direct is NOT included
here because it does NOT eliminate the single-writer lock. You have to have QIO
or ODM with VxFS to avoid the lock.


I hope you enjoy it

---------- Post updated at 07:44 PM ---------- Previous update was at 07:24 PM ----------

Quote:
Originally Posted by radoulov

And another one, could you confirm that the value of sga_max_size (not sga_target) is 5GB?
Yes, its sga_max_size is 5G :
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:


Last edited by ctsgnb; 12-08-2010 at 02:50 PM..
This User Gave Thanks to ctsgnb For This Post:
# 30  
Old 12-09-2010
Quote:
Originally Posted by ctsgnb
[...]
Yes, its sga_max_size is 5G :
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:

Yep, correct.
Thanks!
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