(64).
>
>
>
>
>
>
> >From: Connor McDonald <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> >Subject: Re: How to check/show long SQL statement?
> >Da
TED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: How to check/show long SQL statement?
Date: Wed, 20 Nov 2002 07:30:01 -0800
v$sqltext
order by piece
hth
connor
--- dist cash <[EMAIL PROTECTED]> wrote: >
>
>
&
v$sqltext
order by piece
hth
connor
--- dist cash <[EMAIL PROTECTED]> wrote: >
>
>
> 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
> Statemen
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 = '8758'
order by piece;
It's ugly but all there.
Jerry Whittle
ACIFICS DBA
NCI Information Syste
v$sqlare..??!
Well,
You can check v$sqltext.
Cheers,
RS
--- dist cash <[EMAIL PROTECTED]> wrote:
>
>
>
> 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
Use v$sqltext.
select sql_text from v$sqltext where address = xxx order by piece;
dist cash wrote:
>
> 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 th
