Tracing time spent on the network

From: Chris <user_at_home.com>
Date: Tue, 24 Feb 2009 23:27:36 GMT
Message-ID: <Xns9BBCBBC85AF4Cihavenospecialidtoke_at_127.0.0.1>

Hello, Sorry i am a n00b :)

I have a java application connecting to 10g. My queries appear slow and I believe the network is the issue. I am trying to prove my network admin that most of my time is spent on the network.
Is there a trace facility in the jdbc driver that would show me how long I spend in the driver , versus the network , versus the server ?

I was able to do that with Db2, but I am not sure if Oracle 10g driver has this functionality

[jcc][SystemMonitor:stop] core: 54183.916999999994ms | network: 54097.494ms | server: 54090.311ms

Feel free to point me the to Manual :)
Chris Received on Tue Feb 24 2009 - 17:27:36 CST

This message: [ Message body ]
Next message: johnbhurley_at_sbcglobal.net: "Re: Cheap Cheap Database Recovery"
Previous message: pitufo: "Re: Cheap Cheap Database Recovery"
Next in thread: johnbhurley_at_sbcglobal.net: "Re: Tracing time spent on the network"
Reply: johnbhurley_at_sbcglobal.net: "Re: Tracing time spent on the network"
Maybe reply: Chris: "Re: Tracing time spent on the network"

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

Original text of this message