Re: Question about monitoring tools

From: Randy Reiter <rreiter_at_worldnet.att.net>
Date: Tue, 17 Aug 1999 07:14:47 -0400
Message-ID: <7pbgep$qke$1_at_bgtnsc02.worldnet.att.net>

Attached is a description of the 'Zero Impact Service Level Monitor' and 'Zero Impact Sql Monitor' product line of database monitors for Oracle. Our industry break through approach to database performance monitoring at the SQL statement level requires no impact upon the database server, network or end-user workstations.

The product line can scale to thousands of users and very high transaction processing rates with no required impact upon the database server. The products monitor at the SQL statement level where 80% of all performance problems occur. Other database monitors do NOT monitor SQL performance. Our products may very well save you a hardware upgrade!

Attention consultants and ISVs: Products are great for building performance and tuning practices. Install the products on a laptop, plug it into a client's network and you will be immediately monitoring end-user service levels and SQL performance! Requires no connection to the database server or client workstations. Requires no software installed on the database server, network or end-user work stations.

Available for AIX, HP-UX, Solaris and Windows 95, 98 and NT. A Zero Impact Monitor running on any platform can monitor a database server running of any other platform type (e.g. Sequent, SCO UNIX, Tandem and others).

Look for Sql Power Tools at the following database conferences: Informix User Conference in San Diego, 7/99. Sybase User Conference in Orlando, 8/99. DB2 User Conference in New Orleans, 9/99. Oracle Open World in Los Angeles, 11/99.

Sql Power Tools
info_at_sqlpower.com
201.825.9511

1. Rabin wrote in message <7p99cc$m3q_at_dfw-ixnews4.ix.netcom.com>...
   >We are running 8i with OAS 4.0.7 on a Sun E250 server. We would like to
   >monitor the computer, database, and application server for problems. What
   >software packages are recommended for this (that are reasonably priced).
   >
   >Thanks,
   >Andy Rabin
   >
   >
   

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 Tue Aug 17 1999 - 13:14:47 CEST