Re: Profiler tool

hi,

[Quoted] [Quoted] 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
>
Received on Sat Jul 21 2001 - 23:45:39 CEST