Re: Reverse engineer SQL_TEXT from SQL_ID?

From: joel garry <>
Date: Thu, 25 Feb 2010 09:31:50 -0800 (PST)
Message-ID: <>

On Feb 25, 1:08 am, Randolf Geist <> wrote:

> you might hit the same issue as Kerry Osborne did some time ago:

Dang, I knew it sounded familiar! Should've checked Kerry first.

> For LOB operations Oracle opens a separate cursor that is
> unfortunately not showing up in most of the instrumented areas. Kerry
> shows some ways how to obtain the information using V$OPEN_CURSOR and
> using the PREV_SQL_ID for identifying the statement causing the LOB
> operation.
> The contention on the LOB operation could be caused by what is
> described in the MOS article 740075.1. Since you're not on
> yet you probably can't use the EVENT 44951to work around the problem
> if you're using an ASSM tablespace.
> Your query on DBA_EXTENTS does not work since you first need to
> determine the correct file# and block from the DBA as shown in article
> 419348.1 - in a nutshell use DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE and
> DATA_BLOCK_ADDRESS_BLOCK to get the correct information.



-- is bogus.
Received on Thu Feb 25 2010 - 11:31:50 CST

Original text of this message