Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ART Application SB00 takes too long to respond for more than 1 user

525013May 17 2012 — edited May 23 2012
I am providing a lot of system resources in the System IPC settigs, via the sysctl.conf file and also through the MAXACCSSERS. I am not sure why the SB00 application will only do one transaction at a time. I am quite dumbfounded with this problem. I am not sure why the application is not working properly. From what I understand with Sophia and the other ART Dev, the I should be able to handle concurrent transactions. Thats why I set up the ARTTCPL server -M setting to 900 and -x to 50. I also set the MAX ARTSTRN servers to 50. So far, I am not getting too much. I am not sure where the problem is.

Any ideas,??

When I run this and I do a psr, I see a lot of ARTSTRN servers sitting IDLE. I also see some TMACTIVE transactions. I am not sure why is that happening since my Database I have set MaxCur=120.


Where is the problem in this for it not to behave as specified?


ipcs -l

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 67108864
max total shared memory (kbytes) = 17179869184
min seg size (bytes) = 1

------ Semaphore Limits --------
max number of arrays = 1024
max semaphores per array = 250
max semaphores system wide = 256000
max ops per semop call = 100
semaphore max value = 32767

------ Messages: Limits --------
max queues system wide = 4096
max size of message (bytes) = 65536
default max size of queue (bytes) = 65536

*****************************************************************************


tmboot -c

Fixed Minimums Per Processor

SHMMIN: 1
SHMALL: 1
SEMMAP: SEMMNI

Variable Minimums Per Processor

SEMUME, A SHMMAX
SEMMNU, * *
Node SEMMNS SEMMSL SEMMSL SEMMNI MSGMNI MSGMAP SHMSEG

x3 375 47 370 A + 1 79 158 6845K

where 1 <= A <= 8.

The number of expected application clients per processor should
be added to each MSGMNI value.


***********************************************************************************
tmunloadcf

*RESOURCES
IPCKEY 34701
MASTER "KIXR"
UID 0
GID 0
PERM 0600
MAXACCESSERS 400
MAXACLGROUPS 16384
MAXGTT 100
DOMAINID "KIXD"
MAXGROUPS 100
MAXNETGROUPS 8
MAXMACHINES 256
MAXQUEUES 180
MAXDRT 0
MAXRFT 0
MAXRTDATA 4
MAXSPDATA 100744
MAXSERVERS 180
MAXSERVICES 10000
MAXCONV 64
MODEL SHM
LDBAL Y
CMTRET COMPLETE
MAXBUFTYPE 16
MAXBUFSTYPE 32
SCANUNIT 10
SANITYSCAN 12
DBBLWAIT 2
BBLQUERY 30
BLOCKTIME 10
NOTIFY DIPIN
SYSTEM_ACCESS FASTPATH
MAXINTERFACES 150
MAXOBJECTS 1000
SIGNATURE_AHEAD 3600
SIGNATURE_BEHIND 604800
USIGNAL SIGUSR2
AUTOTRAN N
TRANTIME 30

*MACHINES
"x3" LMID="KIXR"
TUXCONFIG="/opt/oracle/art11gR1/Cics_RT/sample/sample_03/config/tux/tuxconfig"
TUXDIR="/opt/oracle/tuxedo11gR1"
APPDIR="/opt/oracle/art11gR1/Cics_RT/sample/sample_03"
TLOGDEVICE="/opt/oracle/art11gR1/Cics_RT/sample/sample_03/sysfile/TLOG"
TLOGNAME="TLOG"
TLOGSIZE=100
ULOGPFX="/opt/oracle/art11gR1/Cics_RT/sample/sample_03/LOGS/log/ULOG"
ENVFILE="/opt/oracle/art11gR1/Cics_RT/sample/sample_03/config/tux/envfile"
MAXWSCLIENTS=50
CMPLIMIT="MAXLONG,MAXLONG"
NETLOAD=0
SPINCOUNT=0
MAXACLCACHE=100
MAXOBJECTS=1000
SICACHEENTRIESMAX="500"


*GROUPS
"TCP00" LMID="KIXR" GRPNO=1
TMSCOUNT=3
MRM=N
"GRP00" LMID="KIXR" GRPNO=10
ENVFILE="/opt/oracle/art11gR1/Cics_RT/sample/sample_03/config/tux/envfile"
TMSCOUNT=3
MRM=N
"GRP01" LMID="KIXR" GRPNO=11
ENVFILE="/opt/oracle/art11gR1/Cics_RT/sample/sample_03/config/tux/envfile"
TMSCOUNT=3
MRM=N
"GRP02" LMID="KIXR" GRPNO=12
OPENINFO="Oracle_XA:Oracle_XA+Acc=P/sa/passw0rd+SqlNet=orcl+SesTm=600+LogDir=/opt/oracle/art11gR1/Cics_RT/sample/sample_03/LOGS/xa+MaxCur=120+Threads=true"
TMSNAME="TMS_ORA"
ENVFILE="/opt/oracle/art11gR1/Cics_RT/sample/sample_03/config/tux/envfile"
TMSCOUNT=2
MRM=N

*RMS

*NETGROUPS

*SERVERS
"ARTADM" SRVGRP="GRP01" SRVID=10
CLOPT="-o /opt/oracle/art11gR1/Cics_RT/sample/sample_03/LOGS/sysout/stdout_adm -e /opt/oracle/art11gR1/Cics_RT/sample/sample_03/LOGS/sysout/stderr_adm -r --"
SEQUENCE=1
RQPERM=0600 REPLYQ=N RPPERM=0600 MIN=1 MAX=1 CONV=N
SYSTEM_ACCESS=FASTPATH
MAXGEN=1 GRACE=86400 RESTART=N
MINDISPATCHTHREADS=0 MAXDISPATCHTHREADS=1 THREADSTACKSIZE=0
SICACHEENTRIESMAX="500"
"ARTTCPL" SRVGRP="TCP00" SRVID=101
CLOPT=" -- -M 900 -m 50 -x 50 -L //192.168.1.2:34702 -n //192.168.1.2:34701 +H -1"
RQPERM=0600 REPLYQ=N RPPERM=0600 MIN=1 MAX=1 CONV=N
SYSTEM_ACCESS=FASTPATH
MAXGEN=1 GRACE=86400 RESTART=N
MINDISPATCHTHREADS=0 MAXDISPATCHTHREADS=1 THREADSTACKSIZE=0
SICACHEENTRIESMAX="500"
"ARTCNX" SRVGRP="GRP01" SRVID=15
CLOPT="-o /opt/oracle/art11gR1/Cics_RT/sample/sample_03/LOGS/sysout/stdout_cnx -e /opt/oracle/art11gR1/Cics_RT/sample/sample_03/LOGS/sysout/stderr_cnx -r --"
RQADDR="QCNX015"
RQPERM=0600 REPLYQ=Y RPPERM=0600 MIN=1 MAX=1 CONV=Y
SYSTEM_ACCESS=FASTPATH
MAXGEN=1 GRACE=86400 RESTART=N
MINDISPATCHTHREADS=0 MAXDISPATCHTHREADS=1 THREADSTACKSIZE=0
SICACHEENTRIESMAX="500"
"ARTSTRN" SRVGRP="GRP02" SRVID=20
CLOPT="-o /opt/oracle/art11gR1/Cics_RT/sample/sample_03/LOGS/sysout/stdout_strn -e /opt/oracle/art11gR1/Cics_RT/sample/sample_03/LOGS/sysout/stderr_strn -r -- -s KIXR -l SIMPAPP"
RQADDR="QKIX110"
RQPERM=0600 REPLYQ=Y RPPERM=0600 MIN=1 MAX=50 CONV=Y
SYSTEM_ACCESS=FASTPATH
MAXGEN=1 GRACE=86400 RESTART=N
MINDISPATCHTHREADS=0 MAXDISPATCHTHREADS=1 THREADSTACKSIZE=0
SICACHEENTRIESMAX="500"

*MODULES

*JDBCCONNPOOLS

*SERVICES

*INTERFACES

*ROUTING
***********************************************************************************

Edited by: user522010 on May 17, 2012 7:31 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2012
Added on May 17 2012
10 comments
270 views