Re: Queries which causes log file sync
- From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- To: Tanel Poder <tanel@xxxxxxxxxx>
- Date: Fri, 15 Oct 2010 16:10:01 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
