Title: RE: How to check/show long SQL statement?

First find the ADDRESS from v$sqlarea. Then run the following:

select sql_text from v$sqltext
where address = '87584444'
order by piece;

It's ugly but all there.

Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145

    -----Original Message-----
    From:   dist cash [SMTP:[EMAIL PROTECTED]]

    I need check what is SQL statement runnig on ORACLE.  their have two view
    v$sql and v$sqlare.  The entry "sql_text   varchar2(1000)", it is too
    short to show SQL statement.  Some of the sql Statement we use > 3000
    characters.  Does their has way to check/show long SQL statement?


    Thanks.

Reply via email to