using trace response time much faster than without tracing
803898Jan 6 2011 — edited Jan 21 2011Oracle 10.2.0.3 64bit for windows 2003
one very simple statement, "delete from taba where id=**"
when run it without tracing, took about 2 mins
when adding 10046 trace, the response time is less than 2 seconds
repeated this dozens times, all the same problem.
anyone has this problem before?
appreciate your input.