Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10046 trace producing a new wait that is not normally there
Platform?
OS Version?
DB version?
On 8/22/06, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote:
>
> 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.
>
> we got 20,000 'direct path read temp ' waits, but ONLY with a level 12
> trace and ONLY on this update. We have not tested it in multiple
> environments. This is on 10.2 on solaris.
>
> We didn't see this wait in v$active_session_history when we do not have a
> level 12 trace going. I did not see anything about this on metalink. Does
> this strike you as one of those bugs where its one thing in one version in
> one environment, etc...? I have gotten those occasionally?
>
>
>
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 22 2006 - 12:36:04 CDT
![]() |
![]() |