Re: help - Performance problem

From: Randy Reiter <rreiter_at_sqlpower.com>
Date: Mon, 18 Oct 1999 03:00:39 GMT
Message-ID: <6EC14873F507D3119B8C0090273C43490B2110_at_jdasoftware.com>

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 600 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`_at_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@("`_at_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`_at_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`_at_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*("`_at_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*("`_at_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`_at_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@("`_at_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 Mon Oct 18 1999 - 05:00:39 CEST

This message: [ Message body ]
Next message: OraFan: "Any goods books or online resources for learning Designer Ver 6.0"
Previous message: Dan Bork: "Error installing Developer 6.0"
In reply to: Julio Gosmaalho: "help - Performance problem"
In reply to Julio Gosmaalho: "help - Performance problem"
Next in thread: Frank van Bortel: "Re: Designer RME-00011 error"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message