Re: SQL stmts in SGA

From: MarkP28665 <markp28665_at_aol.com>
Date: 1996/12/27
Message-ID: <19961227010900.UAA03193@ladder01.news.aol.com>#1/1

Cut out of original note>>
SGA.
Now...SQL_TEXT is a VARCHAR2(1000) field. What happens if there is a SQL statement that is longer than 1000 characters.
<<

Look in v$sqltext for all the pieces of an sql statement. The sql_text column of v$sqlarea is usually more than ample, but when it is not you can use this other view.

To find the sql statement you must join or subselect with information from v$session on the address and hash_value like you do with v$sqlarea and order it by piece.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Fri Dec 27 1996 - 00:00:00 CST