Re: How to find which sql-statements is Oracle executing?

On Mon, 18 May 1998 12:47:20 +0200, Jorge Ortiz Claver <jorge.ortiz_at_tirea.es> wrote:
> I've got an application working with Oracle. I need to know which
>sql statements it's executing, but i can't find any log file with this
>kind of information. Does anybody knows where must i look or if do i
>have to enable some option in Oracle for this porpose? Thank you in
>advance.
>

You might have a whale of a time with describe v$sqlarea and v$session.

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.