02-24-2009
He's basically saying that prstat is not accurate because of the way shared memory segments work. If you actually need to know the real memory usage then `pmap -x {PID}` will tell you. To do so you will need to either be root or, in this case, be logged in (or use 'su') as the account that owns the processes. So if the process is owned by the Oracle user then you'll need to log in as Oracle or su to Oracle with 'su - oracle`. You will need to know the password for the oracle user to do so.
If you cannot get access to root or the oracle user then you cannot use pmap to get the memory information.
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
Hi,
I need a script which uses prstat command to check the performance . if a load averages crosses some threshold means I should receive the mail. this script should always run in back ground.
Kindly help me on this. (1 Reply)
Discussion started by: jayaramanit
1 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. Shell Programming and Scripting
Hi,
Is there any way by which the unit of size and rss will be only GB while I am running the prstat command? (2 Replies)
Discussion started by: King Nothing
2 Replies
5. 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
6. 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
7. 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
8. Shell Programming and Scripting
Hi,
I know how to figure out the list of PID from my application name :
ptree `pgrep MyApp` | awk '{print $1}'
But I dont know how to pipe it for prstat -p <pidlist>
ptree `pgrep MyApp` | awk '{print $1}' | prstat -p ???
I would like to monitor every ptree PID from my application. ... (4 Replies)
Discussion started by: RickTrader
4 Replies
9. Shell Programming and Scripting
trying to have prstat into a file on a Solaris machine.
Would like to have the prstat run from a cron every 30 min.
print 300 lines+ date.
Date is not printed, only the prstat, and ksh does not end, it stays running...
#!/bin/ksh
# ----------------------------------------------------
#... (4 Replies)
Discussion started by: pointer
4 Replies
10. Solaris
On Solaris 8, when I try to run prstat 30 5 as a background process, the command exits 1-2 seconds after it's initiated instead of the 30 seconds I specified.
It runs fine in interactive mode.
Is there a workaround to this I could use? (Upgrading the package is not an option)
A link to... (1 Reply)
Discussion started by: Devyn
1 Replies
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::oracle::wherejoins
DBIx::Class::Storage::DBI::Oracle::WhereJoins(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)
NAME
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI).
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
DBIx::Class should automagically detect Oracle and use this module with no work from you.
DESCRIPTION
This class implements Oracle's WhereJoin support. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the SQL query, it's already too late.
METHODS
See DBIx::Class::SQLMaker::OracleJoins for implementation details.
BUGS
Does not support full outer joins. Probably lots more.
SEE ALSO
DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::OracleJoins
DBIx::Class::Storage::DBI::Oracle::Generic
DBIx::Class
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.18.2 2013-07-12 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)