Re: Capturing SQL commands

Chuck Hamilton wrote:
>
> Is there a way to capture users' SELECT commands for later analysis?
> --
> Chuck Hamilton
> chuckh_at_dvol.com
>
> This message delivered by electronic sled dogs. WOOF!

alter session set sql_trace = true;

      ---run commands---
alter session set sql_trace = false;

then execute a tkprof on the output file (from he sql_trace) in the users dump destination.

----or----

you can always view all activity in the v$sqlarea view.

-- 
                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo