Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help - Performance problem
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=&@@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-"@T*
M5&ER960@;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(#@P)2!O9B!A;&P_at_9&%T86)A<V4@<V5R=F5R('!E<F9O<FUA;F-E( T*('!RM;V)L96US/R H:2YE+B!T:&4_at_96YD+75S97(@4U%,('-T871E;65N=',I#0H-
M"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(@ M;VYL>2!H:6=H(&QE=F5L(')E<V]U<F-E<RP@=&AE(&-A=7-E(&]F(&%B;W5TM( T*(" R,"4@;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(@<F5S<&]N<V4@ M=&EM92 H<V5R=FEC92!L979E;',I(&%T('1H92!344P@<W1A=&5M96YT(&QE M=F5L( T*9F]R('!R961I8W1I=F4@:61E;G1I9FEC871I;VX@;V8@<&5N9&EN M9R!P97)F;W)M86YC92!P<F]B;&5M<S\@( 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@<W1A=&ES=&EC<RP@#0II;F-R96%S960@=')A;G-A M8W1I;VX@;&]A9',L('!O;W(@<&5R9F]R;6EN9R!344P@<W1A=&5M96YT<RP@M#0IB;&]C:V5D(%-13"!T<F%N<V%C=&EO;G,@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@<F5Q=6ER92!T:&]U<V%N9',@;V8_at_9&]L;&%R<R!I;B!C;VYS=6QT:6YG M(&9E97,@#0IT;R!S971U<"P@:&%V92!A(&AI9V@@8V]S="!O9B!O<&5R871IM;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>#<@: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<@<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,@1$)!<RP_at_061M:6YI<W1R871O<G,@86YD M($AE;' @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(@8V]M<&QA:6YT<RX-"@T*#0I4:&5N('EO=2!N965D('1H92!I;F1U M<W1R>2!B<F5A:RUT:')U(%IE<F\@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-"@T*5&AE('!R;V1U8W0@;&EN92!N;VXM:6YT<G5S:79E;'D_at_86YA;'EZM97,@=&AE(%-13"!N971W;W)K('!A8VME=" -"F9L;W<@=&\@=&AE(&1A=&%B M87-E('-E<G9E<B!F;W(@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@<')O M9'5C="!D;V5S($Y/5"!H879E('1O(')U;B!O;B!T:&4@#0ID871A8F%S92!S M97)V97(L($Y/4B!O;B!C;&EE;G0@=V]R:W-T871I;VYS(&-O;FYE8W1E9"!TM;R!T:&4@<V5R=F5R+B @#0H-"E1H92!P<F]D=6-T<R!R97%U:7)E($Y/(&EN M=')U<VEV92!D871A8F%S92!S97)V97(@;6]N:71O<G,L('-H87)E9"!M96UO M<GD-"G!O;&QI;F<L(&%G96YT<RP@<')O8F5S+"!A=61I=',L(&UI9&1L97=A M<F4@;W(@<')O>'D@<V5R=F5R<RX@($Y/(&%G96YT<R -"F%R92!I;G-T86QL
M960@;VX_at_96YD('5S97(@=V]R:W-T871I;VYS+@T*#0I4:&4@<')O9'5C=',@ M<F5Q=6ER92!.3R!I;7!A8W0@=7!O;B!T:&4_at_9&%T86)A<V4@<V5R=F5R<RP@ M;F5T=V]R:R -"F]R(&5N9"UU<V5R<RX@(%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@M96YD+75S97)S(&-O;FYE8W0_at_9&ER96-T;'D@=&\@=&AE(&1A=&%B87-E( T* M<V5R=F5R("AN;W0@=&AE(&UO;FET;W(I+B @4')O9'5C="!I;G-T86QL871I M;VX@:7,@82!T:')E92!S=&5P( T*<')O8V5S<R!T:&%T(&-A;B!B92!C;VUP M;&5T960@: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(@9&%T86)A M<V4@;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@#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(@6D523R!I;7!A8W0_at_96YD+75S97(@4U%, M( T*(" @('-T871E;65N="!C87!T=7)E+"!P97)F;W)M86YC92!M;VYI=&]RM:6YG+"!344P@<W1A=&5M96YT( T*(" @(')E8V]N<W1R=6-T:6]N(&%N9"!A M;&5R="!N;W1I9FEC871I;VXN#0H-"@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@<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_86QLM('!E<F9O<FUA;F-E('!R;V)L96US+@T*#0I4:&5Y(&1O($Y/5"!C87!T=7)E M(&]R(&UO;FET;W(@870@=&AE(%-13"!S=&%T96UE;G0@;&5V96PL#0IW:&5R
M92 X,"4@;V8_at_86QL(&1A=&%B87-E('-E<G9E<B!P97)F;W)M86YC92!P<F]B M;&5M<R!O8V-U<BX-"@T*5VAY('EO=2!A<VL_("!"96-A=7-E('1H92!M;VYI M=&]R:6YG(&]F(&]P97)A=&EN9R!S>7-T96T@;W(@#0ID871A8F%S92!S97)V M97(@8W!U+"!M96UO<GDL(&1I<VL@<W!A8V4L(&]R(&]T:&5R(&UE=')I8W,@M:7,@#0I%05-9(2 @5&\@;6]N:71O<B!W:71H(%I%4D\@:6UP86-T(&%T('1H
M92!E;F0M=7-E<B!344P@<W1A=&5M96YT( T*;&5V96P@:7,@9&EF9FEC=6QT M("AH;W=E=F5R(&%L;&]W<R!I;6UE9&EA=&4@:61E;G1I9FEC871I;VX@;V8@ M#0IU;F%C8V5P=&%B;&4_at_96YD+75S97(@<V5R=FEC92!L979E;',@86YD('!OM;W(@<&5R9F]R;6EN9R!344PI+@T*#0I4:&4@<F5A;"!B=7-I;F5S<R!P87EO M9F8@=VET:"!D871A8F%S92!M;VYI=&]R:6YG('!R;V1U8W1S(&ES( T*;V)T M86EN960@=VAE;B!M;VYI=&]R:6YG(&]C8W5R<R!A="!T:&4_at_96YD+75S97(@ M4U%,('-T871E;65N=" -"FQE=F5L+"!N;W0@=VAE;B!M;VYI=&]R:6YG(&AI
M9V@@;&5V96P@<WES=&5M(')E<V]U<F-E<RX@(%1H96X@#0IT:&4_at_8V%U<V4@ M;V8@<')O9'5C=&EO;B!D871A8F%S92!S97)V97(@<&5R9F]R;6%N8V4@<')O M8FQE;7,@#0IC86X_at_8F4@:6UM961I871E;'D@<&EN<&]I;G1E9"!T;R!S<&5CM:69I8R!344P@<W1A=&5M96YT<RX-"@T*#0I)5BX_at_0F5N969I=',@;V8@=&AE M(%IE<F\@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@
M82!D871A8F%S92!M;VYI=&]R:6YG('!R;V1U8W0@:7,@;F]W(&%V86EL86)L M92!T:&%T( T*<&5R9F]R;7,@=VAA="!$0D%S(&AA=F4_at_86QW87ES('=A;G1E M9"!A;F0@;F5E9&5D.@T*#0HQ+B!%;F0M=7-E<B!S97)V:6-E(&QE=F5L(&UOM;FET;W)I;F<@=VET:"!A;&5R="!N;W1I9FEC871I;VX@#0H@("!N;W<@<&]S M<VEB;&4@=VET:"!:15)/(&EM<&%C="!U<&]N('1H92!D871A8F%S92!S97)V M97(@#0H@("!A;F0_at_96YD+75S97)S+@T*#0HR+B!344P_at_8V%P='5R92P@<&5R M9F]R;6%N8V4@;6]N:71O<FEN9R!A;F0_at_86QE<G0@;F]T:69I8V%T:6]N( T* M(" @;F]W('!O<W-I8FQE('=I=&@@6D523R!I;7!A8W0@=7!O;B!T:&4_at_9&%T M86)A<V4@<V5R=F5R( T*(" @86YD(&5N9"UU<V5R<RX-"@T*,RX_at_4&EN<&]I M;G1S('1H92!E>&%C="!344P@;W(@4U%,('-T871E;65N="!M:7@@8V%U<VEN M9PT*(" @<&]O<B!P97)F;W)M86YC92X@(%)E8V]N<W1R=6-T:6]N(&]F(&$@ M<V5R=FEC92!L979E;"!M;VYI=&]R:6YG#0H@("!I;G1E<G9A;"!O<B!E;F0M
M=7-E<B!344P@: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@#0H@("!C86X_at_8F4@:6UM961I871E;'D_at_9&5T96-T960_at_870@M=&AE(%-13"!S=&%T96UE;G0@;&5V96PN#0H-"C4N(%)E<75I<F5S($Y/(&EN M=')U<VEV92!D871A8F%S92!S97)V97(@;6]N:71O<G,L(&%G96YT<RP@#0H@ M("!P<F]B97,L(&%U9&ET<RP@;6ED9&QE=V%R92!O<B!P<F]X>2!S97)V97)S
M+B @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',@;V8@=7-E M<G,@=VET:"!N;R!R97%U:7)E9"!I;7!A8W0@=7!O;@T*(" @=&AE(&1A=&%BM87-E('-E<G9E<BX-"@T*-RX_at_5&EM92!F;W(@<F5S;VQU=&EO;B!O9B!D871A M8F%S92!P97)F;W)M86YC92!I<W-U97,@:7,-"B @(&1R86UA=&EC86QL>2!R M961U8V5D+B @36%K97,@1$)!<RP_at_4WES=&5M($%D;6EN:7-T<F%T;W)S( T* M(" @86YD($1E=F5L;W!E<G,@;6]R92!P<F]D=6-T:79E+@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@;V8-"B @(&]W;F5R<VAI<"!I<R!M:6YI;6%L+B @3F\@;F5E9"!T;R!S M<&5N9"!T96YS(&]F('1H;W5S86YD<PT*(" @;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@:&%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 @("!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@#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(@=&\@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(@061V86YC960_at_5&5C:&YO;&]G7>2P_at_26YC+@T*,C Q+C_at_R-2XY-3$Q#0H`