Re: [Tuning] Understanding direct path write event

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 07 Dec 2005 03:38:24 GMT
Message-Id: <pan.2005.12.07.03.38.19.398342@sbcglobal.net>

On Tue, 06 Dec 2005 01:53:17 -0800, SL wrote:

> TFM I read tells me that :
> P1 is 'descriptor address'
> P2 is 'data block address'
> P3 is 'block cnt'
>
> I wonder how I can use the values of those to identify precisely the
> LOB segments involved in the contentions.

The only way I know of is by using DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE and DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK functions and then searching through DBA_EXTENTS.

-- 
http://www.mgogala.com

Received on Tue Dec 06 2005 - 21:38:24 CST