Re: Profiler tool
From: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Wed, 30 May 2001 11:19:23 +0200
Message-ID: <9f2dqm$1p4n8$1_at_ID-54600.news.dfncis.de>
Date: Wed, 30 May 2001 11:19:23 +0200
Message-ID: <9f2dqm$1p4n8$1_at_ID-54600.news.dfncis.de>
try this:
select * from v$sqltext where sql_text like '%v$sql%'
or
select * from v$sqlarea where sql_text like '%v$sql%'
or
select * from v$sql where sql_text like '%v$sql%'
u will see these stmt only once, doesn't matter how offen u r executing them
i'm using: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B148D25.4708EEE5_at_exesolutions.com...
> When I do it in version 8.1.7 I get a list of 59 objects. Among them ...
>
> V$SQLAREA (look at SQL_TEXT)
> V$SQLTEXT (look at SQL_TEXT)
>
> You might want to rerun your query.
>
> Daniel A. Morgan
>
Received on Wed May 30 2001 - 11:19:23 CEST