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:
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)
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)
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)
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)
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)
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)
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)
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)
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)
12-08-2010
