Novice needs tuning help!
Posted in 1998
Hello,
I've included a zip file of an onstat -a. Can anyone tell this informix
novice any obvious problems or changes I can make to improve performance
for my OLTP application? I'm running Informix Online 7.22 on a Sun SPARC
Ultra-2 with 128K RAM (Solaris 2.5.1).
Thank you!
P. Kocsis
pkocsis@earthlink.net
begin 600 osa.ZIP
M4$L#!!0````(`*]KO"2"AA;)"UD``/2B`0`'````;W-A+G1X=*Q::V_;2);]
MG #Y#X7VAW9F;(=OB09Z`-F2$Z%E22W)Z607"Z-(%BUN)%)-4G8\\OW[OK2J^
MBF(ZTBPQT[$HUJE;]W'N@WKW=CR]FRWNQU\\N9_$DBAGYS-(L2F+2NS*,JX=;
M@Q!R>4EF\\27_%OY\\V!%#(P%]S8CF7NOFM=;#VY:A]0SRN_>:L^S=VW=O[UF6
MT2=&)LD3N8LV[)I\\V&?IAR@.DW0;??^0Q!L`O-HD3^_>ZOJU[5P;)B&W:^9_
MVR51G)/;9+O;L)P%UX0$^Y3F*-4+S8A.,N8G<9!=P4KC6M.O#?NTE;"G^W,K
MS>9*$-C43MI3=ZY-XZ25!NQIG;82]G1.6FG"GOW35CK7UFD:,MUK"S0$?A/Y
M=,/]Q[! BF)]]13XRSQ-?' TPKY'@$Q>HGQ-4I;OTYCX2<"(#F[G1?&';%W^
M>^DKG@@N^!CN-YLK^-(@X(6_=._]RX^_Y*)9.C_ "4>W0&FGF=B&/4\\S,02>
M=8J)30P\\^Q03FQAX]BD:,C'P[%,T9&+@V:=HR,3 LT_0T+NWMTD<1D_%]X=(
MD.4^$*'/GWOW]NP?_V\\7@,'_WKQY`_1=,#Q9SNY6?PX6HPNX=7LE'B%D%>4@
MV)M"C*LL#_C](<O\\--JA[-=$S1+-H\\UI2K>@CS03H'\\OW\\]>J,8SLDB2G R]
M;$=]96O\\?C&;K::#^Q&15PI/!UY6?"1R?2#7QR"J6#0?K#X5#WT(V/.'-,B^
M??"UW BTK ?KYA3H!$Q%X,L(EH*&<AK%4?S$-RD@!=KL[FXY6@DTC32O,S(+
MPXSE) D;*PEX4U*@GXOD^5[ +<?_59[(T/"JPRVC?[,66 6 2AM&V3=R'Z5I
MDJ+ W1:#7#U>+&:+"K\\M?H43;N@3.?_*,O(;T2_(-(%_M?<%1EVE*L8/M+GE
M\\$#@>)X"JU)HISJY^LK%+3VB&N;KUZSDZY;OS#]]70YOEB5RVW<FB2]4=B[5
M_![UOBM0>?V"*'?C2:>]^.EK*T@(7$ RM&%3V'IN:<DZF7W$34IA'=*\\SLAT
MO_58BO)M)%"Q6<:7UWV*Z"T1)[5%!X0;1O0I3K(\\\\C/"O6;YL6'NKOH.W?4U
MR]F6;&5-6*I@!RX!/#F;+F>5]D0L@G=D"3S")9/KBWL%CE@^F P6]_/%[.-B
M<-^6HY[=S\\A@0],MV:7)$_B_7(]GDQL,4G\\=/3.RHCL&!(CNA-^O!O/1</2Y
M*6 ,H*7J^ +I?XCZ1BRZF?Q>+M(5>\\E%WB;QOZGJQK5U8^F:8=6-!0%)OT?;
M_9;0;;*/.:\\$-*<$PF&WAX\\QR1&\\Y5U=)YPH1VR?$!?GRBGENMHIVX<LUQT\\
MZ$0YZ<&#=A]R4X W#SJ#K 6.C!^6J\\%'$'!V0PY?9VIJ^R 7DRRG3\\A--&64
M-+RD%9G+T>+S:#%]N)>@;;YZB*._]D#W`?APFK)L!T4"@L-1*)$Y-8IARQCM
M`8PD$&562^ECX#7PIL#>7!\\LI/M-SO7BT0Q(A:7/+*T@!I/Q8%EQ1@UB$F5<
MI70#:2"F.<,\\PE=CA@3"F(Y6JZ_S*BSS393[NXL+((Z+V_D#0!2*`&](P%7R
M-:@J.,_><Y:/69Z_[O TH\\%P,KO]_7$UOA_-'E;$4?0CC)Q'<"30QPN-<D%A
MX"Y13 *0,XV\\/=;W+'Z&NF4!'C,<35?%^K:Z[Y+4QVS"LBA@L?_:F;6 Q1XF
MJS&PQ^UHN<0<V ;3^'$R,->&7>Y$PY&D%U#LX?TMJ#^J;H/:'NY!.Y_GA<[U
M%F!%TWM0.#GW=_OWY'D'*E^.IQ\\GHT=8__AY3@X),PY)G,27_V9I<D$VT19T
M%9=P`(0XJ,4DYG$]G8'[UP#:@$4'Q9T=R/3N[G&)ZNA<, A#2-KY*P9(FI/:
MR7'M%-<N_W9M)7.Y/I,QMJ:8R^_9-DE?E3H%O:CNRD8KA16T&-<RH?\\-%M\\\\
MW-V-%M5B\\R>69D(4;Q^&7 "P[& \\JRRK7G7+CF?"HE@:X-[%,]C\\-]<T"@.Q
M5XLE9Q_K& = ZJF[$V-Y/_A2KFE7#X=TUZHB;B>CP;2FR!]YMQ3$WS :P[_2
MTHBR_'1_`[14KM*^4ZU9,Y6.L!6.P,F-!@&$M%C_>;RH:F33;IKSC*";12#Z
M<Y3F>V3S!EK&GK8,,@KJB*,-AL-J=5]W&PJNRNV8O1Q&RFJ:!KC5;#68%,O;
M8;!*\\I9(Q?HKHOWVKWW,0YM!)W;[^WPUGJX^%W!FTV^1A;$Q):(SA?\\#A0/X
M.3 G]*)H^,5#PV'[I'G5+0;/$LA3>UXO+AX>P6$>AZ#HKZ3E,&?\\X1T#HH5]
M`U S&(D!B0A[8W+C9Y! XVD)9/X]$(N#-LSJRZ<_[ZMU=BN+3!+,J"F-,^KS
MDGT=/:TAGX!*R):FWXI-H'3D<*,Z7CLI_2W<.?ON;_89E%-8LGTITINXM.^Z
MX2N(JQH8IKL$JIC*4%"J`+U5M5 [RI<Y;9=0M<)DCD7QDOOT&4'&X&B718$1
M)Q#)\\1-RPWZW2U+PVGP=9<1OM(:[@G*O^!B@NE;8J<+]+6+E:RP!GV07`WD,
M>/*UV A07I,]1/R&YEB&*T 9$^LW%"J0#5\\0$M %%G5AFFSYEWZRW=(XN""_
M)E@7Y>32^Y5/5?A @/D)%"JOY#--(^IQ9H*R#_+/8G3[>?'U<?5I`57'\\AIO
M5^Z-1]MLV(:\\).DWN"4*E@QG.+RU17G2`AIR.XUA5<@E!-[)H<GD.IE-_Z-M
M$#560-^];0L/Q;#J`$-9[E447<C7W K@5!D/,/4!M/@@&._^L/)>L-TFDOUP
M0_7#Q>!A-;L&K@.C`=]B=90R;.\\)%H$7Q("/H%8@<5D4\\@65-&V2'"X(W>?)
M%G;S2?8"M><Z$:7M`O@0BMN"8<VVFA8@AJPH/9:_,!;C/9F/0HC9-52"5>0-
M%\\W8/8@(]2SJY4#@#A>3V7)U-WN8BB32GO$%*33"&<3"'HB-H^''?XK/M4X8
M57D+W]9T"Q\\?9?[G:=?0K :#GXD(%-F:H,'0Q^11=TFRJ5$%8HU ;Z5+7#0I
MYHPPR!U["DY9.NTYD.8E%):7S[L+R+\\1VIYN)-APB279GX,Q:,XFS0N.N>35
M%R_H2ZW)`:D$^.-A]#"Z'W$:MC2WD6,.-;DR688\\.%^YKGB^4OCP!GARO_NP
M$/%%GBMUW@P6CX/;%:J4;_(AW^X^>#1]!%KFPPKQ"":^&Z#CAWG;-<43B]%J
M\\57>44-+/#&]>?PRGRU6C[?@&:M6-(N'OH!5'\\&XCYRJ306I8#L:D,$:_UMS
MC,7@<0[%?2.WU]OO)B,],=X6T!SRQ"['/]&\\A"(JQT*?6'Z:3<HZJ)Y^VE@;
M%N806R&J-V;?<_*4)ON=I(J;Y7QP.UJ-[N><&6568'_M(W O)BPYO,'ON267
MHRNRPD0492(OR,Y4#MPXP>1K2 'XI01;_C$AH_B)LU4$O><^X\\VC#Z>"3A8/
M27*N* +QQUD;.J=LQ_PHC"!7@4=N]QF>`/IO/X&T"+&,O(U=IKJ_V)Q]A]L(
M]+(&.JF)DHGD"\\)[H(.G=2YI](J(;BVO]KW K!*%B (9HMJ@$@Q*0BCB0$T1
M/(Q^F^RA-PO(.O'1T],(GN8'%B?EJH'#)BG%L, :'7MF]&H^3P#K\\NQ2,TEK
MQBD,7"0#KKI*\\]R>#_?S?W!+KN#4(;3ZR0N23%DI\\!(B3Y,-5PL2/%=?;5XH
MV%"^*%E'_AK10&,[2($X<PB$5B$U[F,:PY)HQTW!<+2+Z()XR#F%!B+E?X8T
MVNQ3',?Z_C[%D>19D6&+,@2HBV^971'^]1U@X6&@0A_=7_ _/][.%B/8-^"?
M^ <=6 ;J-/*591>8T/B':2+T" ]!'5OJC2NZH<>Y/)%R?%%I077+?*"D5X'$
MY9 K#Z3G/6"C=^Y>:]VH8$"Q7@@OK@,)M%B/+K7%6FV/0PSRZQ/>^E5 U!!^
M"N+\\3YIB57[-ST,]7D4*?;^7B-5@YH?=8;/]`<MPL<"$VUW&:>'=VS=P0:3(
MV0N?EOP*P0(MH!R\\W8TGDSN@\\^+EA=M*W'<8*R%%I7-0;Q]M>(:,XH!]+SP<
MO'B=!/P!Z3O )4@IW"N+JA>7@:NER&"8S]Z]?5B.(/./[[N-H%US'-Z70=[D
MZ\\ZQT'Q_@2^GGYB $G7O;'F>06P5;RZ*,G)8#/?^D 1PO@O^PE<ND*3FPS_F
MB_%L,8;62F^UAF4"Q9 %9<.Z'5!*&N7H04N>YB %+\\8')H3DT$0@`)[B/P^1
M'43)21R.M[V/X-.S,C76X8;J8J7U):5,R]O!E$ND0[5C]ZJL]E,R93Y$[!L`
M&ZP&R]_'\\V(QU,J*1),6TR<D^Q;)/#:;KVYG]_/Q=(B?-/+;O\\@4*@K,$$FR
M(_\\+';<D8T@CP&10<:%'GX/3@".73<\\N`7^%5 1,]8R]%XBX92G$D@! [EG3
M;"T^7O%U.NX%R8/3::UIC+)D(TATB[]N@ C$]%)M]4O*=HSRQ,?S^R^0<';@
M7U A@NNS-7V&,U+.1^?&^VJ=Q\\ _@"1GL&'Z$J'#YNKSVGL,]V<F)#10PH<,
M^[0,&"!E3S0--CA(3'X@=KDAB@_[M=6)^0_/%#.<%4'^V[S6SE<J&66M#@:Q
M`3*"&*4K[" S-%8FL9 4I:_L*KX[-*"!9C\\6!4>I0-ZE364F'<[^G,*C2HN.
M3BY?Q@;)2\\S7XNMS\\!UR.YNNQM.'$;9&OY'!#52&V!;]1K!\\?O=V<O/P.(<2
M#*?VAX4J,XOHFW$F!WS%)WZ\\W.4GNQW<?AJ5<[XV2!$^B7S+X5-_??!5Y"<H
M%A8SJ%WO[Z&Z/_\\(Z?B%OF+.E]F9&[8YGJ_9'&&D'W]"^DR>6,RPEKF%OAZ<
M"UR7Q>BG@8BM<UG1)^B!!+L0B)<?+(9MY>JFH(?*=>!I+!J*;E9.$0E_*8!E
M$$\\H`?S!Q_%XY?FK6,Q[%WX'FQ<^2R:Q:(P(B5^ 2#&%T)ZA:7H??REW.;^\\
M'%9YK^@"R65Q1VO\\(3X9O9[%.:ZOVYHM\\"R<;PF\\NVK1S^&5]RS-,ARG)Q#[
M_5+"FZI;.Q)1$UB^KU6G[?U'6+H6@EQ?.=8E<?2^> '(?]F 5XE%:>BX05\\"
M"!7K&OZ"#R[#DF@V-N]U-+,#+>AI'M6::(8FT"S'$FBNTY3-=#K07+MOV4W9
MW")OZ99$"Z@BFWX8S=.8[_85-%?.30W;X6@`UY3-[I+-,QS-4_2F2^' +02:
MHS=EP]\\:'D0+#6KZBMZT`JV0C5IUV4RSUS^,YNF!H=K4U:1#E;*QOJ(WXS :
M#33;4:U0ZJUG<#33\\!1_ZSJII_5;_J87_E:@.:&B-[L#S>^Y6E]%<\\0LI]";
MZ1F*O_4ZT)C=;UG!L/E)B.D(O9FAH^BMPT,\\S;/:D27T0@Q#>*]ENHIL'3:E
M(6VAN3VAME)O5B]09.LZJ6>$S%-.JLL)G>4*O5F^IL1"EQ4H;?F;KKE-#K$U
MJRF;W>5OKFWXIFI333B<:4@TJZ?HS3V,YFD]&O9:D25*#*,O;&KW/45O'6A
ME@=L*E^:%/YF^TR)A2Z]!;JC6L'5)+\\5-G6 /YMZZ^!>3W=97U<\\I%_$J;2"
M8]N*33O8DE*?!DHLN#V9@@OO=5Q7D:TSZIGE6ZJ_R;=#NBM/&OB*;%H'6L\\7
MKR;KLCFR:BS0L'IH6J$KLKQ HRW9I/>6:(Y9DTTW1,HZ*%NH]12VU(HOA0UZ
MC-:PH!'3NFP0&(;F%%CB?'K/MKFOFS:0"<?K&TRKRV:(,N302?N:[S9/*OB&
M%++U>WKSG+TNK,#I5[))K5FFH C7=3F:R]FTGK&Z3NJWN5*FWLH&$"[U<_:L
MSG,R8!_%/QQ#6D&<T[,Q^V&MM1 ZTSNPM,8?XBDTF6V:52[UG7I.`#2S`PW.
MR1R_>4ZH$LP>'D4W)!JMYP13TQ1?PU\\`\\?4>E,=]MXEFVHUS!EZ#)\\$"'1D!
MTC)K,YM,, 6S!6&#)TW3Z<Q]3BO+]_L%>TAF8R939.O@24]KYQ?.=!Q-,AOK
M&TW9^EU<Y&I&BR<+[RAE\\^L\\"185NQW.+ZZ:K2Q7A(VE"=E"3>%)LZM^]DW:
M4V0#MY"FE15(:/D-V411>0BM#Y6[PD7@Z0ZO"@RK8/'0U9J:ZW5H#OU-Y0_7
MEKQ;H@5UID0[=.4KT)P3--%ZO:)*%6BFIO<4JVJ'T6@`]9&IRB;K(UDUF)I-
M%=FZ,G-(;9Z>ZK+I0L]%-)B:RQ39NMBMKUF<\\VMHCB%/"L6O0&-Z4[9>5^<!
M'&*K[&8VNR(3RE9%MJYJR],AG3;1=$T3U%J<