Sponsored Content
Full Discussion: prstat log
Operating Systems Solaris prstat log Post 302250456 by radoulov on Thursday 23rd of October 2008 11:11:12 AM
Old 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

Help with prstat

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

prstat in shell

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

prstat log

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

understanding the prstat log

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

prstat O/P

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

prstat

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

prstat

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

prstat output

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

Understanding prstat

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

Capture PRSTAT

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