Re: Profiler tool

Steffen Ramlow wrote:

> 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
> >

[Quoted] As well you should. What is your point?

Daniel A. Morgan Received on Sat Jul 21 2001 - 23:47:05 CEST