Re: help - Performance problem

From: Randy Reiter <rreiter_at_sqlpower.com>
Date: Sun, 17 Oct 1999 07:40:54 -0400
Message-ID: <7ucd2u$fsv$1_at_bgtnsc01.worldnet.att.net>


The Zero Impact Sql Monitor will capture/filter all SQL statements sent to the database server. SQL can be reconstructed by any combination of time period, login id, session id, key words in the SQL text, server, database, client IP address, application, end-user response time, database server response time, rows returned, network time, blocked process ratio, and more.

Product is non-intrusive, requires no connections to the database server and does not poll shared memory.

Scales to thousands of users with no impact upon the database server 24x7. Installation is a few minutes.

Refer to www.sqlpower.com.

Julio Gosmaalho wrote in message <7uavlm$ksu$1_at_duke.telepac.pt>...
>Hi. I have in a call center a solution with a oracle database 7.3.
>When the desktop app. finishes in the clients, there are some data thats
>comitted in certain tables of the db.
>Only when this occurs it takes a long time (sometimes 1 minute !!!!) to
>write the data in the db.
>It seems a performance problem of the database or of the structure of the
>tables ?
>How can i trace by table (or by session) and what conclusions can I reach ?
>
>Thanks,
>
>JG
>
>

begin 666 zero_wins_ora.txt
M5&AE($1A=&%B87-E(%-13"!A;F0_at_4V5R=FEC92!,979E;"!-;VYI=&]R('=I M=&_at__at_6D523R!I;7!A8W0@=VEN<R$-"CT]/3T]/3T]/3T]/3T]/3T]/3T]/3T] M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T-"_at_T* M5&ER960_at_;V8_at_9&%T86)A<V4@;6]N:71O<G,@=&AA="!D;R!.3U0_at_8V%P='5R M92!O<B!M;VYI=&]R('1H92 -"G!E<F9O<FUA;F-E(&]F('=H870_at_8V%U<V5S M(#_at_P)2!O9B!A;&P_at_9&%T86)A<V4@<V5R=F5R('!E<F9O<FUA;F-E( T*('!R M;V)L96US/R H:2YE+B!T:&4_at_96YD+75S97(@4U%,('-T871E;65N=',I#0HM" E1I<F5D(&]F(&1A=&%B87-E(&UO;FET;W)S('1H870_at_9&\@3D]4(&UE87-U M<F4_at_96YD+75S97(-"G-E<G9I8V4@;&5V96QS(&%N9"!344P@<W1A=&5M96YT M('!E<F9O<FUA;F-E(&EN('!R;V1U8W1I;VX_( T*("AT:&5Y(&UO;FET;W(_at_ M;VYL>2!H:6=H(&QE=F5L(')E<V]U<F-E<RP_at_=&AE(&-A=7-E(&]F(&%B;W5T M( T*(" R,"4_at_;V8_at_86QL(&1A=&%B87-E('!E<F9O<FUA;F-E('!R;V)L96US M*0T*#0I4:7)E9"!O9B!D871A8F%S92!M;VYI=&]R<R!T:&%T(&1O(&YO="!M M;VYI=&]R(&5N9"UU<V5R(&]R(&1A=&%B87-E#0IS97)V97(_at_<F5S<&]N<V4@ M=&EM92 H<V5R=FEC92!L979E;',I(&%T('1H92!344P_at_<W1A=&5M96YT(&QE M=F5L( T*9F]R('!R961I8W1I=F4_at_:61E;G1I9FEC871I;VX@;V8@<&5N9&EN M9R!P97)F;W)M86YC92!P<F]B;&5M<S\_at_( T*:2YE+B!P;V]R(&1A=&%B87-E

M('!E<F9O<FUA;F-E(&-A=7-E9"!B>2!D:7-K('-P86-E(&9R86=M96YT871I
M;VXL( T*<VME=V5D(&1I<W1R:6)U=&EO;B!S=&%T:7-T:6-S+"!O=71D871E
M9"!D:7-T<FEB=71I;VX_at_<W1A=&ES=&EC<RP@#0II;F-R96%S960@=')A;G-A
M8W1I;VX_at_;&]A9',L('!O;W(@<&5R9F]R;6EN9R!344P@<W1A=&5M96YT<RP@
M#0IB;&]C:V5D(%-13"!T<F%N<V%C=&EO;G,_at_87,@=V5L;"!A<R!O=&AE<B!P M97)F;W)M86YC92!I<W-U97,N#0H-"E1I<F5D(&]F(&1A=&%B87-E(&UO;FET
M;W)S('1H870_at_87)E(&EN=')U<VEV92P_at_9&EF9FEC=6QT( T*=&\@:6YS=&%L
M;"P_at_<F5Q=6ER92!T:&]U<V%N9',@;V8_at_9&]L;&%R<R!I;B!C;VYS=6QT:6YG
M(&9E97,_at_#0IT;R!S971U<"P@:&%V92!A(&AI9V@@8V]S="!O9B!O<&5R871I
M;VX_at_86YD(&%R92!E>'!E;G-I=F4_#0H-"E1I<F5D(&]F(&1A=&%B87-E(&UO M;FET;W)S('1H870_at_87)E('-O(&EN=')U<VEV92!T:&5Y(&%R92 -"FYO="!U M<V5D(#(T>#<_at_:6X@<')O9'5C=&EO;B!E;G9I<F]N;65N=',_#0H-"E1I<F5D M(&]F(&1A=&%B87-E(&UO;FET;W)S('1H870_at_9&\@;F]T('-C86QE('=E;&P@ M=VAE;B!A9&1I=&EO;F%L#0IU<V5R<R!A<F4_at_861D960@;W(@=&AE('1R86YS M86-T:6]N('!R;V-E<W-I;F<_at_<F5Q=6ER96UE;G1S(&EN8W)E87-E/PT*#0I4 M:7)E9"!O9B!D871A8F%S92!M;VYI=&]R<R!T:&%T(&1O(&YO="!M96%S=7)E M(%-E<G9I8V4_at_3&5V96P@<W5C:"!A<PT*96YD+75S97(@<F5S<&]N<V4@=&EM M92P_at_9&%T86)A<V4@<V5R=F5R(')E<W!O;G-E('1I;64_at_86YD(&]T:&5R( T* M;65T<FEC<R!W:&EC:"!A;&QO=W,_at_1$)!<RP_at_061M:6YI<W1R871O<G,_at_86YD M($AE;' _at_1&5S:W,@=&\@#0IP<F]A8W1I=F5L>2!D971E8W0_at_86YD(')E<V]L
M=F4_at_9&%T86)A<V4@<&5R9F]R;6%N8V4@:7-S=65S('!R:6]R( T*=&\@96YD
M+75S97(_at_8V]M<&QA:6YT<RX-"@T*#0I4:&5N('EO=2!N965D('1H92!I;F1U
M<W1R>2!B<F5A:RUT:')U(%IE<F\_at_26UP86-T(%-Q;"!A;F0@#0I397)V:6-E
M($QE=F5L($UO;FET;W)S('!R;V1U8W1S(&9R;VT_at_4W%L(%!O=V5R(%1O;VQS M(0T*#0H-"DDN(%!R;V1U8W0_at_3W9E<G9I97<-"CT]/3T]/3T]/3T]/3T]/3T] M/3T-"_at_T*5&AE('!R;V1U8W0@;&EN92!N;VXM:6YT<G5S:79E;'D_at_86YA;'EZ M97,_at_=&AE(%-13"!N971W;W)K('!A8VME=" -"F9L;W<@=&\@=&AE(&1A=&%B M87-E('-E<G9E<B!F;W(_at_96YD+75S97(@4U%,('-T871E;65N="!A;F0@<V5R
M=FEC92!L979E;" -"G!E<F9O<FUA;F-E(&UO;FET;W)I;F<N("!4:&4_at_<')O
M9'5C="!D;V5S($Y/5"!H879E('1O(')U;B!O;B!T:&4_at_#0ID871A8F%S92!S
M97)V97(L($Y/4B!O;B!C;&EE;G0_at_=V]R:W-T871I;VYS(&-O;FYE8W1E9"!T
M;R!T:&4_at_<V5R=F5R+B @#0H-"E1H92!P<F]D=6-T<R!R97%U:7)E($Y/(&EN M=')U<VEV92!D871A8F%S92!S97)V97(_at_;6]N:71O<G,L('-H87)E9"!M96UO M<GD-"G!O;&QI;F<L(&%G96YT<RP_at_<')O8F5S+"!A=61I=',L(&UI9&1L97=A M<F4_at_;W(@<')O>'D@<V5R=F5R<RX@($Y/(&%G96YT<R -"F%R92!I;G-T86QL
M960_at_;VX_at_96YD('5S97(@=V]R:W-T871I;VYS+_at_T*#0I4:&4@<')O9'5C=',@
M<F5Q=6ER92!.3R!I;7!A8W0_at_=7!O;B!T:&4_at_9&%T86)A<V4@<V5R=F5R<RP@
M;F5T=V]R:R -"F]R(&5N9"UU<V5R<RX_at_(%1H92!P<F]D=6-T<R!R97%U:7)E
M(&YO(&-O;FYE8W1I;VYS('1O('1H92 -"F1A=&%B87-E('-E<G9E<B!A;F0_at_ M96YD+75S97)S(&-O;FYE8W0_at_9&ER96-T;'D@=&\@=&AE(&1A=&%B87-E( T* M<V5R=F5R("AN;W0_at_=&AE(&UO;FET;W(I+B @4')O9'5C="!I;G-T86QL871I M;VX_at_:7,_at_82!T:')E92!S=&5P( T*<')O8V5S<R!T:&%T(&-A;B!B92!C;VUP M;&5T960_at_:6X_at_82!F97<@;6EN=71E<RX-"@T*#0I)22X_at_4')O9'5C="!,:6YE M#0H]/3T]/3T]/3T]/3T]/3T]#0H-"E1W;R!P<F]D=6-T<R!F;W(_at_9&%T86)A M<V4_at_;6]N:71O<FEN9R!A="!T:&4_at_96YD+75S97(@4U%,(&QE=F5L.@T*#0HQ M+B G6F5R;R!);7!A8W0_at_4V5R=FEC92!,979E;"!-;VYI=&]R)R!F;W(@,C1X M-R!E;F0M=7-E<B!A;F0_at_#0H@(" @9&%T86)A<V4@<V5R=F5R(%-E<G9I8V4@ M3&5V96P_at_36]N:71O<FEN9R!W:71H(&%L97)T<RX-"@T*,BX@)UIE<F\@26UP M86-T(%-Q;"!-;VYI=&]R)R!F;W(_at_6D523R!I;7!A8W0_at_96YD+75S97(@4U%,
M( T*(" _at_('-T871E;65N="!C87!T=7)E+"!P97)F;W)M86YC92!M;VYI=&]R
M:6YG+"!344P_at_<W1A=&5M96YT( T*(" @(')E8V]N<W1R=6-T:6]N(&%N9"!A
M;&5R="!N;W1I9FEC871I;VXN#0H-"_at_T*24E)+B!#;VUP87)I<V]N('1O(&-O
M;G9E;G1I;VYA;"!D871A8F%S92!M;VYI=&]R<PT*/3T]/3T]/3T]/3T]/3T] M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/0T*#0I#;VYV96YT
M:6]N86P_at_9&%T86)A<V4@;6]N:71O<FEN9R!P<F]D=6-T<R!M;VYI=&]R(&UA
M:F]R(')E<V]U<F-E( T*=7-A9V4_at_<W5C:"!A<R!C<'4L(&UE;6]R>2P_at_9&ES
M:R!S<&%C92P_at_971C+B @5&AE(&-A=7-E(&]F(&%B;W5T#0HR,"4@;V8_at_86QL
M('!E<F9O<FUA;F-E('!R;V)L96US+_at_T*#0I4:&5Y(&1O($Y/5"!C87!T=7)E M(&]R(&UO;FET;W(_at_870@=&AE(%-13"!S=&%T96UE;G0@;&5V96PL#0IW:&5R
M92 X,"4_at_;V8_at_86QL(&1A=&%B87-E('-E<G9E<B!P97)F;W)M86YC92!P<F]B
M;&5M<R!O8V-U<BX-"_at_T*5VAY('EO=2!A<VL_("!"96-A=7-E('1H92!M;VYI
M=&]R:6YG(&]F(&]P97)A=&EN9R!S>7-T96T_at_;W(@#0ID871A8F%S92!S97)V
M97(_at_8W!U+"!M96UO<GDL(&1I<VL@<W!A8V4L(&]R(&]T:&5R(&UE=')I8W,@
M:7,_at_#0I%05-9(2 @5&\@;6]N:71O<B!W:71H(%I%4D\@:6UP86-T(&%T('1H
M92!E;F0M=7-E<B!344P_at_<W1A=&5M96YT( T*;&5V96P@:7,_at_9&EF9FEC=6QT
M("AH;W=E=F5R(&%L;&]W<R!I;6UE9&EA=&4_at_:61E;G1I9FEC871I;VX@;V8@
M#0IU;F%C8V5P=&%B;&4_at_96YD+75S97(@<V5R=FEC92!L979E;',_at_86YD('!O
M;W(_at_<&5R9F]R;6EN9R!344PI+_at_T*#0I4:&4@<F5A;"!B=7-I;F5S<R!P87EO M9F8_at_=VET:"!D871A8F%S92!M;VYI=&]R:6YG('!R;V1U8W1S(&ES( T*;V)T M86EN960_at_=VAE;B!M;VYI=&]R:6YG(&]C8W5R<R!A="!T:&4_at_96YD+75S97(@ M4U%,('-T871E;65N=" -"FQE=F5L+"!N;W0_at_=VAE;B!M;VYI=&]R:6YG(&AI
M9V_at_@;&5V96P@<WES=&5M(')E<V]U<F-E<RX@(%1H96X@#0IT:&4_at_8V%U<V4@
M;V8_at_<')O9'5C=&EO;B!D871A8F%S92!S97)V97(@<&5R9F]R;6%N8V4@<')O
M8FQE;7,_at_#0IC86X_at_8F4@:6UM961I871E;'D@<&EN<&]I;G1E9"!T;R!S<&5C
M:69I8R!344P_at_<W1A=&5M96YT<RX-"@T*#0I)5BX_at_0F5N969I=',@;V8@=&AE M(%IE<F\_at_26UP86-T(%-Q;"!-;VYI=&]R:6YG#0H@(" @("!A;F0_at_6F5R;R!) M;7!A8W0_at_4V5R=FEC92!,979E;"!-;VYI=&]R:6YG#0H]/3T]/3T]/3T]/3T] M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]#0H-"D9I;F%L;'D_at_
M82!D871A8F%S92!M;VYI=&]R:6YG('!R;V1U8W0_at_:7,@;F]W(&%V86EL86)L
M92!T:&%T( T*<&5R9F]R;7,_at_=VAA="!$0D%S(&AA=F4_at_86QW87ES('=A;G1E
M9"!A;F0_at_;F5E9&5D._at_T*#0HQ+B!%;F0M=7-E<B!S97)V:6-E(&QE=F5L(&UO
M;FET;W)I;F<_at_=VET:"!A;&5R="!N;W1I9FEC871I;VX@#0H@("!N;W<@<&]S M<VEB;&4_at_=VET:"!:15)/(&EM<&%C="!U<&]N('1H92!D871A8F%S92!S97)V M97(_at_#0H@("!A;F0_at_96YD+75S97)S+_at_T*#0HR+B!344P_at_8V%P='5R92P@<&5R M9F]R;6%N8V4_at_;6]N:71O<FEN9R!A;F0_at_86QE<G0@;F]T:69I8V%T:6]N( T* M(" _at_;F]W('!O<W-I8FQE('=I=&@@6D523R!I;7!A8W0@=7!O;B!T:&4_at_9&%T M86)A<V4_at_<V5R=F5R( T*(" @86YD(&5N9"UU<V5R<RX-"@T*,RX_at_4&EN<&]I M;G1S('1H92!E>&%C="!344P_at_;W(@4U%,('-T871E;65N="!M:7@@8V%U<VEN M9PT*(" _at_<&]O<B!P97)F;W)M86YC92X@(%)E8V]N<W1R=6-T:6]N(&]F(&$@ M<V5R=FEC92!L979E;"!M;VYI=&]R:6YG#0H_at_("!I;G1E<G9A;"!O<B!E;F0M
M=7-E<B!344P_at_:7,@<&]S<VEB;&4_at_8GD@<V5V97)A;"!C<FET97)I82X-"@T*
M-"X_at_5')E;F1I;F<@9&%T86)A<V4@<V5R=FEC92!L979E;"!O<B!344P@<&5R
M9F]R;6%N8V4_at_#0H@("!C86X_at_8F4@:6UM961I871E;'D_at_9&5T96-T960_at_870@
M=&AE(%-13"!S=&%T96UE;G0_at_;&5V96PN#0H-"C4N(%)E<75I<F5S($Y/(&EN M=')U<VEV92!D871A8F%S92!S97)V97(_at_;6]N:71O<G,L(&%G96YT<RP@#0H@ M("!P<F]B97,L(&%U9&ET<RP_at_;6ED9&QE=V%R92!O<B!P<F]X>2!S97)V97)S M+B _at_3D\@86=E;G1S( T*(" @87)E(&EN<W1A;&QE9"!O;B!E;F0@=7-E<B!W M;W)K<W1A=&EO;G,N#0H-"C8N(%-C86QE<R!T;R!T:&]U<V%N9',_at_;V8@=7-E M<G,_at_=VET:"!N;R!R97%U:7)E9"!I;7!A8W0@=7!O;@T*(" @=&AE(&1A=&%B M87-E('-E<G9E<BX-"_at_T*-RX_at_5&EM92!F;W(@<F5S;VQU=&EO;B!O9B!D871A M8F%S92!P97)F;W)M86YC92!I<W-U97,_at_:7,-"B @(&1R86UA=&EC86QL>2!R M961U8V5D+B _at_36%K97,_at_1$)!<RP_at_4WES=&5M($%D;6EN:7-T<F%T;W)S( T* M(" _at_86YD($1E=F5L;W!E<G,@;6]R92!P<F]D=6-T:79E+_at_T*#0HX+B!0<F]D M=6-T(&EN<W1A;&QA=&EO;B!I<R!A(&9E=R!M:6YU=&5S+B!/;F=O:6YG(&-O M<W0_at_;V8-"B @(&]W;F5R<VAI<"!I<R!M:6YI;6%L+B @3F\@;F5E9"!T;R!S M<&5N9"!T96YS(&]F('1H;W5S86YD<PT*(" _at_;V8_at_9&]L;&%R<R!O;B!P<F]D M=6-T(&EN<W1A;&QA=&EO;BP_at_8V]N9FEG=7)A=&EO;B!A;F0@=')A:6YI;F<N
M#0H-"CDN(%1H92!:97)O($EM<&%C="!3<6P_at_36]N:71O<B!A;F0_at_6F5R;R!)
M;7!A8W0_at_4V5R=FEC92!,979E;"!-;VYI=&]R:6YG#0H@("!P<F]D=6-T(&UA
M>2!S879E('EO=2!A;B!E>'!E;G-I=F4_at_:&%R9'=A<F4@=7!G<F%D92X-"@T*
M,3 N(%-E<G9I8V4_at_3&5V96P_at_36]N:71O<FEN9R!O9B!E;F0M=7-E<B!R97-P M;VYS92!T:6UE+"!D871A8F%S92!S97)V97(-"B _at_("!R97-P;VYS92!T:6UE M(&%N9"!O=&AE<B!M971R:6-S(&%L;&]W<R!$0D%S+"!!9&UI;FES=')A=&]R
M<R!A;F0_at_#0H@(" @2&5L<"!$97-K<R!T;R!P<F]A8W1I=F5L>2!D971E8W0@
M86YD(')E<V]L=F4_at_9&%T86)A<V4@<&5R9F]R;6%N8V4-"B @("!I<W-U97,@
M<')I;W(_at_=&\@96YD+75S97(@8V]M<&QA:6YT<RX-"@T*#0II;F9O0'-Q;'!O
M=V5R+F-O;0T*=W=W+G-Q;'!O=V5R+F-O;0T*#0I3<6P_at_4&]W97(@5&]O;',- M"E1H92!$979E;&]P;65N="!'<F]U<"!F;W(_at_061V86YC960_at_5&5C:&YO;&]G 7>2P_at_26YC+_at_T*,C Q+C_at_R-2XY-3$Q#0H`
`
end Received on Sun Oct 17 1999 - 13:40:54 CEST

Original text of this message