10-26-2010
SunOS 5.9 sun4u sparc and Oracle 10.2.0.4
9 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. Post Here to Contact Site Administrators and Moderators
Could RSS-support mod be installed for this forum? (3 Replies)
Discussion started by: eugrus
3 Replies
3. Solaris
I have a question about the accuracy of prstat.
I did a 'prstat -t' and it shows 99% of my memory is occupied by oracle.
NPROC USERNAME SIZE RSS MEMORY TIME CPU
194 oracle 343G 340G 99% 86:17.24 56%
However, 'top' shows I still have 7762meg of memory free.
Memory: 16G real, 7762M... (4 Replies)
Discussion started by: zen03
4 Replies
4. 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
5. Solaris
Hi Guys,
I have observed the Oracle (DB USER) is utilizing 100% of the memory in the prstat -a output. I am bit confused is it normal and if not how to bring it down? ABout the machine it is a SunOS 5.10 Generic_125100-10 sun4v sparc SUNW,Sun-Fire-T200.
Please see below output of prstat -a... (12 Replies)
Discussion started by: Asteroid
12 Replies
6. Solaris
Hi Export,
i execute 'top' command to show the free memory in Solaris host, but the read is much lower than the RSS value shown in prstat command. Which one can reflect the real status and it is possible the difference caused by any patch of OS?
Top command (only 883 memory is free)... (3 Replies)
Discussion started by: eiga
3 Replies
7. Solaris
Hi,
I have some question about memory in Solaris.
How it's possible that prstat -a show me that some process using 230M RSS and when I'm using pmap -x show me that this same process using only 90M RSS ? (0 Replies)
Discussion started by: deivo
0 Replies
8. Solaris
Hi,
someone please explain me what's the difference b/w rss and swap in PRSTAT.
i'm getting output like below,
NPROC USERNAME SWAP RSS MEMORY TIME CPU
70 weblogic 48G 46G 73% 449:17:03 0.4%
swap always remains... (11 Replies)
Discussion started by: sunnys7143
11 Replies
9. Solaris
Hi,
When I sum the RSS number in the ps command for a specific user and compare it with the RSS values of the prstat command of the same user - there is a big difference.
Server details: Solaris 10 5/09 s10s_u7wos_08 SPARC
prstat output:
NPROC USERNAME SWAP RSS MEMORY TIME ... (2 Replies)
Discussion started by: amitlib
2 Replies
LEARN ABOUT DEBIAN
dbix::class::storage::dbi::oracle::wherejoins
DBIx::Class::Storage::DBI::Oracle::WhereJoins(3pm) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Oracle::WhereJoins(3pm)
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.14.2 2011-05-10 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3pm)