Re: Grabbing SQL statements from memory

From: <nasof_at_hotmail.com>
Date: Wed, 19 Aug 1998 12:13:55 GMT
Message-ID: <6refi3$6ph$1@nnrp1.dejanews.com>

Try modifying the SQL below to suit your needs: select sql_text from v$sqltext_with_newlines where address in (

	select sql_address
	from v$session
	where sid in (
		select sid
		from v$session
		where osuser='Frank') )
	and hash_value in (
		select sql_hash_value
		from v$session
		where sid in (
			select sid
			from v$session
			where osuser='Frank') )

order by address, piece

In article <01bdcb4b$8d076620$bf12ea9e_at_UKP014921.logica.co.uk>,   "Nexus Product Centre" <clarkej_at_logiica.com> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 19 1998 - 07:13:55 CDT