Re: event 10079 question

  • From: Tanel PÃder <tanel.poder.003@xxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 1 Dec 2005 14:33:49 -0600

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.

Other related posts: