Re: latch: row cache objects - not parsing
Date: Wed, 2 Jun 2010 22:14:38 -0700
Plus Tanel has the latch analysis script of all latch analysis scripts:
On Wed, Jun 2, 2010 at 2:49 PM, Taral Desai <taral.desai_at_gmail.com> wrote:
> You can user session address from v$session to join back to
> On Wed, Jun 2, 2010 at 3:04 PM, Christo Kutrovsky <
> kutrovsky.oracle_at_gmail.com> wrote:
>> Hello All,
>> I am having a weird issue on Oracle 11.2 64 bit SPARC with T2+ CPUs.
>> Occasionally my loading process (bulk insert statement) will have a large
>> number of consecutive waits (as reported by ASH) of "latch: row cache
>> objects". The statement is not been reparsed, and ASH reports
>> I do have "blocked by" information, and that is pointing to a parallel
>> merge statement been executed at the same time. The blockee also shows "N"
>> for all "IN_xx" columns in ASH. The
>> Does anyone know how to get more information for which objects from the
>> rowcache I am contending, and why at all?
>> I am suspecting it's the parallel merge that is affecting the system
>> globally, as a lot of queries just "don't run" during these short freezes.
>> Christo Kutrovsky
>> Senior Consultant
>> I blog at http://www.pythian.com/blogs/
> Thanks & Regards,
> Taral Desai