Re: Profiler tool

Steffen Ramlow wrote:

> hi,
>
> after checking out the dictionary views i found v$sql, but this view
> contains only one row per different statement, so when i do:
>
> select * from x;
> select * from x;
> select * from x;
>
> i will find only one "select * from x" in v$sql
>
> what i want is a complete history of all statements and the corresponding
> session ids
>
> is this available?
>
> "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3B125CCB.20DB3AA6_at_exesolutions.com...
> > Steffen Ramlow wrote:
> >
> > > i have heard that somewhere in our world people exist, which know
 oracle
> > > and sql server
> > >
> > > ok, here it comes:
> > >
> > > sql server profiler is a tool which allows to monitor all statements
 send to
> > > the server
> > > the profiler has many filtering capabilities and a rich and handy gui
> > >
> > > maybe i'm looking for a gui for oracle trace and audit
> > >
> > > "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message
> > > news:3B11A96C.4097F630_at_exesolutions.com...
> > > > wayne wrote:
> > > >
> > > > > > does anybody knows a free tool for Oracle like SQL Servers
 Profiler?
> > > > >
> > > > > What exactly does the SQL Server Profile do, and what platform are
 you
> > > > > running?
> > > >
> > > > Excellent questions. Steffen joins a long list of other SQL Server
 types
> > > > that somehow figure that SQL Server may have capabilities not present
 in
> > > > far superior databases and who assumes that because it is a Microsoft
> > > > product we should either know, or care, about it.
> > > >
> > > > Perhaps we will learn something about SQL Server ... and he will learn
> > > > something about Oracle.
> > > >
> > > > Daniel A. Morgan
> > > >
> >
> > There are people that claim to know both products. But I've yet to meet
 one
> > whose knowledge of Oracle wasn't superficial. Meaning they could hack
 around but
> > couldn't do anything that couldn't use a rewrite. (to whom it may concern:
 if
> > you are the one and only exception to the rule please don't waste either
 of our
> > times telling me so because I haven't met you).
> >
> > Oracle does not provide a tool of this type with a GUI interface but does
> > provide the data as part of the data dictionary which can be queried by
 any
> > query tool. Perform the following query:
> >
> > SELECT object_name
> > FROM dba_objects
> > WHERE object_name LIKE '%SQL%';
> >
> > you will find a number of resources.
> >
> > Daniel A. Morgan
> >

[Quoted] 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 Sat Jul 21 2001 - 23:46:22 CEST