Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Network monitoring tools w/Oracle "visibility"?!?
"mitiste" <mitiste_at_iit.edu> wrote in message
news:pan.2003.04.30.17.19.02.830293_at_iit.edu...
> Hi, everyone,
>
> Sorry for cross-posting - don't know who may have an answer for me, and it
> is Oracle-across-the-board related question: in an attempt to get a
> better handle on the Oracle 9i deployment we have, forms servers and
> Apache install, we would like to be able to get some monitoring tools for
> end-to-end transactions (client to server). I have some rudimentary
> processes right now, consisting mostly of an Oracle client-server network
> transaction simulator, and network sniffers, but it is very time consuming
> to read all this data and put them together, in order to determine when
> specific sessions have problems because of network or within the servers
> themselves.
>
> We looked so far at Compuware's product, then at NetIQ, but I am not sure
> they can prove to be good enough in regards to "understanding" the Oracle
> transactins as well as impact of underlying network infrastructure (LAN,
> WAN, etc.).
>
> Anybody having any suggestions/experience with this?
>
> Thx,
> Stef
>
AIX comes with iptrace / ipreport, which allows you to dump traffic to the port level. There might be shareware ports to other platforms. Of course sqlnet has it's own tracing capability and trcassist to break down the trace file, including statistics.
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Wed Apr 30 2003 - 15:27:09 CDT