RE: 10046 trace producing a new wait that is not normally there
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <ryan_gaffuri@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 22 Aug 2006 10:23:30 -0700
Did you have exactly the same execution plan when you ran with the level
1 trace and no trace as the plan you had with the level 12 trace? Same
bind variables for the query?
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
ryan_gaffuri@xxxxxxxxxxx
Sent: Tuesday, August 22, 2006 10:10 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 10046 trace producing a new wait that is not normally there
We have an update statement that runs in 3 minutes with no trace or a
level 1 trace, but ran for 2 hours and we killed it with a level 12
trace.
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
