10-23-2008
Quote:
Originally Posted by
dipashre
[...]
Please confirm whether the oracle user can use more memory than the SGA+PGA taken together.
The SGA is allocated per oracle instance. The prstat total statistics are wrong as far as the shared memory is concerned.
The PGA is only a target (soft limit) so yes, an oracle process can use more than that limit. Note that there are other memory areas (outside of the PGA) to consider too.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello,
The last line of prstat shows load average.
I am unable to figure out what actually it is.
I have read the man pages and also googled, all for no use.
Can somebody help me, as to what should be the avg. load of the system for best performance and how is this load of prstat calculated. (6 Replies)
Discussion started by: vibhor_agarwali
6 Replies
2. Shell Programming and Scripting
Hello,
How can I do to use prstat command in a korn-shell ?
Thanks a lot.
Rgds. (4 Replies)
Discussion started by: madmat
4 Replies
3. Solaris
Hi All,
Operating System and Version: SunOS,Solaris 10 sparc(64 bit)
RDBMS Version: 10.2.0.4.0
But the prstat logs of my system shows:-
NPROC USERNAME SWAP RSS MEMORY TIME CPU
83 cemsbin 5204M 3604M 22% 53:46:00 6.7%
2 adm 244M 240M 1.5% 15:13:53 3.5%
77 oracle 17G 10G 65% 4:24:47... (0 Replies)
Discussion started by: dipashre
0 Replies
4. Solaris
Can some one please explain what does the memory part mean in the prstat logs?
NPROC USERNAME SIZE RSS MEMORY TIME CPU
61 oracle 36G 33G 71% 109:44:26 12%
89 cemsbin 12G 9523M 20% 195:02:41 11%
2 adm 273M 199M 0.4% 47:05:42 2.3%
89 root ... (9 Replies)
Discussion started by: dipashre
9 Replies
5. Solaris
Good Evening everyone,
I am confused about prstat O/P as it shows memory values which are different from actual value.Below is the O/P of prstat command and swap commands.
NPROC USERNAME SIZE RSS MEMORY TIME CPU
48 root 2113M 1590M 1.2% 45:09.39 32%
31 daemon ... (7 Replies)
Discussion started by: vvpotugunta
7 Replies
6. Shell Programming and Scripting
hi all,
am writing a ksh script on solaris 9 to get the number of threads taken by a process. am using the prstat -p command to do this.
output i get is :
:"/export/home/user" > prstat -p 25528 | cut -f2 -d/
NLWP
203
Total: 1 processes, 203 lwps, load averages: 2.58, 3.24, 3.62... (2 Replies)
Discussion started by: cesarNZ
2 Replies
7. Solaris
hi all,
was trying to figure out how busy my app was by looking at the performance of the app server. did a 'prstat -s rss' command to find the app servers using most memory.
Found a command 'prstat -m' which is meant to show more details on each pid but the output of this command... (1 Reply)
Discussion started by: cesarNZ
1 Replies
8. Shell Programming and Scripting
hi all,
have a ksh script where i am doing a prstat -m -u osuser 1 1 >> $FILE_NAME but for some reason it only writes 15 lines wheres when i run the same command manually from command prompt it prints out 60 lines.
why is it not writing the full 60 lines to the file ??
ta. (1 Reply)
Discussion started by: cesarNZ
1 Replies
9. Solaris
Hello
We have a SPARC box running Solaris 10. We have 32 GB of physical memory, 32 GB of swap. Now i want to monitor memory usage for performance tuning. The box is running Sybase database. When I type prstat i get the following
PID USERNAME SIZE RSS STATE PRI NICE TIME CPU... (4 Replies)
Discussion started by: abohmeed
4 Replies
10. Solaris
Is there any scripts to capture the process which use more than 5% CPU from prstat output? (9 Replies)
Discussion started by: tharmendran
9 Replies
plimit(1) User Commands plimit(1)
NAME
plimit - get or set the resource limits of running processes
SYNOPSIS
plimit [-km] pid...
plimit {-cdfnstv} soft,hard... pid...
DESCRIPTION
If one or more of the cdfnstv options is specified, plimit sets the soft (current) limit and/or the hard (maximum) limit of the indicated
resource(s) in the processes identified by the process-ID list, pid. Otherwise plimit reports the resource limits of the processes identi-
fied by the process-ID list, pid.
Only the owner of a process or the super-user is permitted either to get or to set the resource limits of a process. Only the super-user
can increase the hard limit.
OPTIONS
The following options are supported:
-k On output, show file sizes in kilobytes (1024 bytes) rather than in 512-byte blocks.
-m On output, show file and memory sizes in megabytes (1024*1024 bytes).
The remainder of the options are used to change specified resource limits. They each accept an argument of the form:
soft,hard
where soft specifies the soft (current) limit and hard specifies the hard (maximum) limit. If the hard limit is not specified, the comma
may be omitted. If the soft limit is an empty string, only the hard limit is set. Each limit is either the literal string unlimited, or a
number, with an optional scaling factor, as follows:
nk n kilobytes
nm n megabytes (minutes for CPU time)
nh n hours (for CPU time only)
mm:ss minutes and seconds (for CPU time only)
The soft limit cannot exceed the hard limit.
-c soft,hard Set core file size limits (default unit is 512-byte blocks).
-d soft,hard Set data segment (heap) size limits (default unit is kilobytes).
-f soft,hard Set file size limits (default unit is 512-byte blocks).
-n soft,hard Set file descriptor limits (no default unit).
-s soft,hard Set stack segment size limits (default unit is kilobytes).
-t soft,hard Set CPU time limits (default unit is seconds).
-v soft,hard Set virtual memory size limits (default unit is kilobytes).
OPERANDS
The following operands are supported.
pid Process ID list.
EXIT STATUS
plimit returns the exit value zero on success, non-zero on failure (such as no such process, permission denied, or invalid option).
FILES
/proc/pid/* process information and control files
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWesu |
+-----------------------------+-----------------------------+
SEE ALSO
ulimit(1), proc(1), getrlimit(2), setrlimit(2), proc(4), attributes(5),
SunOS 5.10 8 Jun 1998 plimit(1)