Re: How can I see SQL executed by users?

The SQL in SQL_TEXT is stored in pieces. The following shows you how to put the pieces together. This worked on 7.x, should work on 8.x.

• get current queries by session, user

select

   username, sql_text, command_type
from

   v$session a, v$sqltext b
where

   username is not null and
   a.sql_address = b.address
order by b.address, piece

DET wrote:

> I want to be able to see the full sql statements executed by a program. I've
> tried v$sqltext, but it's too short - cuts off the interesting parts.
>
> I don't have to see the stuff real-time. A log file would be fine. The
> server is 7.3.4, running on SCO OS5, and the client program is as well. Any
> advice?
Received on Thu Oct 15 1998 - 11:07:46 CDT