RE: RE: TKPROF output
- From: "Jorgensen, Finn" <Finn.Jorgensen@xxxxxxxxxxxxxxxxx>
- To: 'ORACLE-L' <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 31 Mar 2011 09:41:02 -0400
Lyall,
In your new (slow) setup is there a significant difference in the network
between the app server and the db server compared to the prod (fast) setup?
E.g. is the app and db server in different data centers or different parts of
the data center or is there now a firewall or some other device between the app
server and db server? Anything that can introduce significant latency would
cause the wait event you see.
It's also possible there's something else running on the app server that slows
its processing of the fetched rows down. Have you run a vmstat or something
similar on the app server to ensure it has sufficient CPU resources available
while the query runs?
Are you sure that the app executing the query is exactly the same as prod? I.e.
if it's a newer release it's possible the app itself does more with the data
between fetches contributing to the slowness.
Thanks,
Finn Jorgensen
>>> This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely for the
addressee. If you are not the intended recipient, do not use the information
in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2
--
//www.freelists.org/webpage/oracle-l
Other related posts:
