10-27-2008
I saw you've already posted the problem on the Oracle forums but I think you should rather open an SR to Oracle Support. Status 11 seems to be related to number of processes OS limits (it should be 12 for memory shortage).
Hence I would try to increase process.max-file-descriptor and try to reproduce the problem.
Last edited by radoulov; 10-27-2008 at 10:02 AM..
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
LEARN ABOUT OSX
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.16.2 2012-08-16 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)