| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> [oracle-l] High Load Average on APP Server on Compiliing Application with 64 Bit SO - HELP
After Compiling Application Software, On Production Application Server
machine, from NON-SO 32-bit To SO (Shared Object) with 64 Bit, when
Concurrent application User logins crosses 500 , CPU Utilization becomes
100 % with "load average" becoming 400 (from uptime Command).
Additional Logins thereafter into the Application of additional users
becomes extremely SLOW. Login into the application calls a set of SO
files one after another.
NOTE - Application software Code remains the same from NON-SO 32 Bit to
SO 64-Bit.
truss taken under load of the login shows High Waits on the functions=20
fork()
mmap()
fstat()
NOTE - There is NO Load on Database Server machine
Previously with the NON-SO 32-bit Application even with 4000 Concurrent User logins, CPU Utilization would be 95+% with a "load average" of only 70 on the SAME APP. Server machine.
2 Sample Compile Statements used with the SO mode, 64 Bit Compiler Below:-
C++ Compiling
CC -c tmp_bauu9014.cxx -o bauu9014.o -xtarget=3Dultra -xarch=3Dv9
-DB2K_SunOS_PLATFORM -D_REENTRANT -DPRECOMP -DSLMXMX_ENABLE
-DSLTS_ENABLE -KPIC -DB2K_SHARED_LIB -DMethodOne -DINF_BSD
-DINF_UNIX_SRC -DINF_ORACLE_SRC -DINF_MINI_RPC_CLIENT
-DDFLT_RND_FLG=3D"'N'" -DWT_UNIX_SRC -DB2K_POST_PC_COMPILE
-DBANCS_2000_RELEASE -DSQLCA_STORAGE_CLASS=3Dextern -DPROTOTYPE
-I/users3/test10 -I/usr/java/include -I/usr/java/include/solaris
-I/module7/app/FIN70IC/fincore/v7.0/base/common/comminc
-I/module7/app/FIN70IC/fincore/v7.0/base/common/include
-I/module7/app/FIN70IC/fincore/v7.0/base/common/proto/extf_inc
-I/module7/app/FIN70IC/tbaforms/v2.2/include
-I/rdbms/oracle/ora92-64/precomp/public
-I/rdbms/oracle/ora92-64/rdbms/demo
-I/module7/app/FIN70IC/soar/v2.2/include-I/module7/app/FIN70IC/arch/v1.x
/cc/arch/sources/c_include -I/module7/app/FIN70IC/standin/v1.2/include
2) Sample Compilation line for Pro*C Code :-
Pro*C++ Compiling
/rdbms/oracle/ora92-64/bin/proc parse=3Dnone code=3Dcpp include=3D/module7/app/FIN70IC/fincore/v7.0/base/common/include include=3D/module7/app/FIN70IC/fincore/v7.0/base/common/comminc include=3D/module7/app/FIN70IC/soar/v2.2/includeinclude=3D/rdbms/oracle/ora92-64/precomp/public iname=3Dtmp_ladr5001.pxx oname=3Dtmp_ladr5001.cxx sqlcheck=3DFULL userid=3Dtbaadm/ehlehkb9_at_70ic maxopencursors=3D150 unsafe_null=3Dyes dbms=3Dv8
C++ Compiling
CC -c tmp_ladr5001.cxx -o ladr5001.o -xtarget=3Dultra -xarch=3Dv9
-DB2K_SunOS_PLATFORM -D_REENTRANT -DPRECOMP -DSLMXMX_ENABLE
-DSLTS_ENABLE -KPIC -DB2K_SHARED_LIB -DMethodOne -DINF_BSD
-DINF_UNIX_SRC -DINF_ORACLE_SRC -DINF_MINI_RPC_CLIENT
-DDFLT_RND_FLG=3D"'N'" -DWT_UNIX_SRC -DB2K_POST_PC_COMPILE
-DBANCS_2000_RELEASE -DSQLCA_STORAGE_CLASS=3Dextern -DPROTOTYPE
-I/users3/test10 -I/usr/java/include -I/usr/java/include/solaris
-I/module7/app/FIN70IC/fincore/v7.0/base/common/comminc
-I/module7/app/FIN70IC/fincore/v7.0/base/common/include
-I/module7/app/FIN70IC/fincore/v7.0/base/common/proto/extf_inc
-I/module7/app/FIN70IC/tbaforms/v2.2/include
-I/rdbms/oracle/ora92-64/precomp/public
-I/rdbms/oracle/ora92-64/rdbms/demo
-I/module7/app/FIN70IC/soar/v2.2/include
-I/module7/app/FIN70IC/arch/v1.x/cc/arch/sources/c_include
-I/module7/app/FIN70IC/standin/v1.2/include
Machine SF15000=20
OS - Solaris 9
Oracle 9.2.0
Application - High OLTP Banking Application=20
File systems VXFS=20
Number of CPUs on Application Server =3D 36
Will provide any info needed.
Qs How Can we approach this issue?
Qs Will putting the Application software files (SO files) onto a
tmpfs(memory based file system) help temporarily ?
Qs Are the Compile Commands (Above) Optimal? Can any Additional
parameters be specified to improve this? Can any share their
Compile/Link Commands?
Qs Any advisable parameters in /etc/system file for SF15K, SF6800
machines?=20
Can any Share their /etc/system files for such machines?
Qs Should we consider RE-Compiling the Application in NON-SO, 64-Bit?
REQUEST - I am moving ON-Site. May I request any replies Directly include my HOTMAIL ID (shown in CC) please,=20 as I may NOT be able to access the oracle-l/sunmanagers LISTs as well as this E-mail-ID from On-site.=20
Thanks
 |
 |