Re: latch: row cache objects - not parsing
- From: kyle Hailey <kylelf@xxxxxxxxx>
- To: taral.desai@xxxxxxxxx
- Date: Wed, 2 Jun 2010 22:14:38 -0700
Plus Tanel has the latch analysis script of all latch analysis scripts:
-
http://blog.tanelpoder.com/2008/07/09/advanced-oracle-troubleshooting-guide-part-7-sampling-latch-holder-statistics-using-latchprof/
-
http://blog.tanelpoder.com/2008/07/23/advanced-oracle-troubleshooting-guide-part-8-even-more-detailed-latch-troubleshooting-using-latchprofx/
-
http://blog.tanelpoder.com/2009/03/r/another-latchprofx-use-case/<http://blog.tanelpoder.com/2009/03/20/another-latchprofx-use-case/>
Best Wishes
Kyle Hailey
http://db-optimizer.blogspot.com/
On Wed, Jun 2, 2010 at 2:49 PM, Taral Desai <taral.desai@xxxxxxxxx> wrote:
> You can user session address from v$session to join back to
> v$rowcache_parent
>
> On Wed, Jun 2, 2010 at 3:04 PM, Christo Kutrovsky <
> kutrovsky.oracle@xxxxxxxxx> 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
>> "IN_SQL_EXECUTION".
>>
>> 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
>> Pythian.com
>> I blog at http://www.pythian.com/blogs/
>>
>
>
>
> --
> Thanks & Regards,
> Taral Desai
>
Other related posts:
