Re: event 10079 question

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Thu, 1 Dec 2005 14:33:49 -0600
Message-ID: <048c01c5f6b6$a7f79ab0$35bc21c8@porgand>

Hi,

Which platform are you on?

If 10046 doesn't show anyhting obvious (e.g. only minority of total client response time is recorded in there), then you either need to start guessing whether the problem is in app code or network latency (by running simultaneous pinging and vmstat/mpstat on client/app server) or go the proper way and instrument database calls in the client code.

This can be quite easily done at OCI level, transparently, without modifying applications source code - take a look into $ORACLE_HOME/rdbms/demo/ociucb.c (if the demos are installed). Adding a simple timing call to this program would show you the db call response times from client perspective and if you combine it with 10046 trace info, you could find out whether the majority of total client response time is spent in app code, db server process or somewhere in between (network stacks, transport, network layer).

Tanel.

Original Message ----- From: rjamya To: Oracle Discussion List Sent: Thursday, December 01, 2005 12:06 PM Subject: event 10079 question

Here is dumb question,

I have a remote user who often complains about slowness, sometimes it is network, sometimes it isn't. Network guys are doing their bit to identify, I need to do my bit. will a trace with 10046 and 10079 highlight any network issues?

told you it was a dumb question. we are doing 10046 to identify if there are any sql bottlenecks. TIA
Raj

This space is available for rent.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 01 2005 - 14:37:13 CST