We are having some performance problems at a client. I ran a 10046 trace,
level 8 on the DB for about 5 minutes of test operations. From the trace
files generated I find someting of the following:
SELECT Tm_trade_in_error.trade_id, Tm_trade_in_error.account_number,
Tm_trade_in_error.aps_groupid,
No, I don't think you're reading this wrong. May be you've had
a network problem or a NIC acting up?
-Original Message-
Sent: Tuesday, March 18, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
We are having some performance problems at a client. I ran a 10046 trace,
level 8 on the
This is trace data from 9.2.0.2+ (you can tell because of the new STAT
data). Therefore the timings are expressed in microseconds (0.01-second
units).
Technically, to answer your question, you have to know whether or not the
application invokes the fetch immediately after the execute. It