Re: Grabbing SQL statements from memory

Hi,

You should query v$sqlarea or v$sql_text

Jeroen

Nexus Product Centre wrote:

> Hi guys and gals,
>
> Can anyone help me with the following problem??
>
> I have an Oracle 7.3.2.x database and need to track some SQL statements
> that are causing a problem.
>
> I can identify the problem user's sid and serial# from v$session and can
> join to v$open_cursor to get the sql_text.
>
> Unfortunately this is defined as VARCHAR2(60) so I get a truncated SQL
> statement.
>
> How can I retrieve the full statement???
>
> TIA
>
> Jon
Received on Wed Aug 19 1998 - 05:38:28 CDT