Re: Queries which causes log file sync

On Fri, Oct 15, 2010 at 3:50 PM, Tanel Poder <tanel@xxxxxxxxxx> wrote:
>>
>> Hi
>>
>> Did you check what is that objects
>>
>> obj#=32461
>>
>> maybe it give you some light.
>>
>
> Note that the memory structure underlying the obj# printout is populated by
> things like IO waits, some enqueue waits (I think) and buffer busy waits
> etc. However, these values aren't cleared, so whatever is the next wait
> event (which doesn't overwrite the obj#) - it may just report some old
> wait's obj#...

BTW

This same issue appear to exist in v$session tables when session is
going from waiting to on cpu state - it looks like latest wait event
is not cleared as well - sometimes can be useful but can also do some
unnecessary mess.

-- 
Marcin Przepiorowski
http://oracleprof.blogspot.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: