Re: TX - row lock contention enq

From: Martin Berger <>
Date: Wed, 8 Apr 2009 10:22:43 +0200
Message-ID: <>

Hi Ram,

I don't know a way to get this informations from statspack, as it's collection method is far to gross for such questions. If you have licensed Diagnostic pack, you can query ASH/AWR data. Especially ASH can give you much more infos:
in v$active_session_history you can find all waits and events for a giving sample time (timestamp) or check the change of event and seq# of a given session over time. (just 2 ways to start the checks)

sorry for the little information,

Received on Wed Apr 08 2009 - 03:22:43 CDT

Original text of this message