Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Grabbing SQL statements from memory

Re: Grabbing SQL statements from memory

From: Jeroen van Sluisdam <Jeroen.van.Sluisdam_at_vrijuit.nl>
Date: 19 Aug 1998 10:38:28 GMT
Message-ID: <35DAAAFF.28A0DA08@vrijuit.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US