We were receiving out of process memory errors - unable to allocate .. bytes of memory for PGA
Could you provide the exact error code and message (ORA- ...)?
Quote:
vmstat - sr was increasing constantly and used oracle EM to monitor memory usage
The scan rate is not enough, check if si/so have values different than 0
(or if pi/po have high values) with vmstat -S.
Quote:
I can check within Oracle by checking v$pgastat , v$process etc
Could you post the output from:
Quote:
Based on the average RSS size I am multuiplying it by total processes to compute total memory usage
of these processes, is this the right way of computing the memory usage of these processes?
Just sum the RSS values of all those processes:
---------- Post updated at 11:53 AM ---------- Previous update was at 11:42 AM ----------
Could you also post the output of the following command:
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)
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,
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT ULTRIX
vmstat
vmstat(1) General Commands Manual vmstat(1)Name
vmstat - report virtual memory statistics
Syntax
vmstat [ interval [ count ] ]
vmstat -v [ interval [ count ] ]
vmstat -fKSsz
vmstat -Kks namelist [ corefile ]
Description
The command reports statistics on processes, virtual memory, disk, trap, and cpu activity.
If is specified without arguments, this command summarizes the virtual memory activity since the system was last booted. If the interval
argument is specified, then successive lines are summaries of activity over the last interval seconds. Because many statistics are sampled
in the system every five seconds, five is a good specification for interval; other statistics vary every second. If the count argument is
provided, the statistics are repeated count times.
When you run the format fields are as follows:
Procs: information about numbers of processes in various states.
r in run queue
b blocked for resources (i/o, paging, and so on.)
w runnable or short sleeper (< 20 seconds) but swapped
faults: trap/interrupt rate averages per second over the last 5 seconds.
in (non clock) device interrupts per second
sy system calls per second
cs cpu context switch rate (switches/second)
cpu: breakdown of percentage usage of cpu time
us user time for normal and low priority processes
sy system time
id cpu idle time
Memory: information about the use of virtual and real memory. Virtual pages are considered active if they belong to processes which are
running or have run in the last 20 seconds.
avm active virtual pages
fre size of the free list
Pages are reported in units of 1024 bytes.
If the number of pages exceeds 9999, it is shown in a scaled representation. The suffix k indicates multiplication by 1000 and the suffix
m indicates multiplication by 1000000. For example, the value 12345 appears as 12k.
page: information about page faults and paging activity. These are averaged every five seconds, and given in units per second. The size
of a unit is always 1024 bytes and is independent of the actual page size on a machine.
re page reclaims (simulating reference bits)
at pages attached (found in free list not swapdev or filesystem)
pi pages paged in
po pages paged out
fr pages freed per second
de anticipated short term memory shortfall
sr pages scanned by clock algorithm, per-second
disk: s0, s1 ...sn: Paging/swapping disk sector transfers per second (this field is system dependent). Typically paging is split across
several of the available drives. This will print for each paging/swapping device configured into the kernel.
Options-f Provides reports on the number of forks and vforks since system startup and the number of pages of virtual memory involved in each
kind of fork.
-K Displays usage statistics of the kernel memory allocator.
-k Allows a dump to be interrogated to print the contents of the sum structure when specified with a namelist and corefile. This is
the default.
-S Replaces the page reclaim (re) and pages attached (at) fields with processes swapped in (si) and processes swapped out (so).
-s Prints the contents of the sum structure, giving the total number of several kinds of paging related events that have occurred since
boot.
-v Prints an expanded form of the virtual memory statistics.
-z Zeroes out the sum structure if the UID indicates root privilege.
Examples
The following command prints what the system is doing every five seconds:
vmstat 5
To find the status after a core dump use the following:
cd /usr/adm/crash
vmstat -k vmunix.? vmcore.?
Files
Kernel memory
System namelist
vmstat(1)