Re: ASSM bug: slow INSERT after uncomitted DELETE
From: ca111026 <ca111026_at_gmail.com>
Date: Tue, 11 Aug 2009 00:10:26 -0700 (PDT)
Message-ID: <d4a0b7a5-aa4e-41bc-9adb-ecd251c56019_at_g1g2000pra.googlegroups.com>
Sorry, how buffer busy waits are related to ASSM? I thought buffer busy waits ('read by other session' in later versions) is event that happens when multiple sessions are reading the same block from memory. This is why it is called 'buffer' (from 'buffer cache'). If table is "narrow" i.e. rows are short then there will be many rows per block, ASSM or no ASSM. Received on Tue Aug 11 2009 - 02:10:26 CDT
Date: Tue, 11 Aug 2009 00:10:26 -0700 (PDT)
Message-ID: <d4a0b7a5-aa4e-41bc-9adb-ecd251c56019_at_g1g2000pra.googlegroups.com>
Sorry, how buffer busy waits are related to ASSM? I thought buffer busy waits ('read by other session' in later versions) is event that happens when multiple sessions are reading the same block from memory. This is why it is called 'buffer' (from 'buffer cache'). If table is "narrow" i.e. rows are short then there will be many rows per block, ASSM or no ASSM. Received on Tue Aug 11 2009 - 02:10:26 CDT