Re: Oracle BG processes and SQL visibility in 10.2.0.2

On Sat, 30 Sep 2006 15:44:47 -0700, Luso Joe wrote:

> Sorry, I thought from your original post you wanted to see wht SQL was
> being executed by the job process.

Thank you for your efforts, but I just wanted to use session monitor. Your instructions are good, but as I'm using Oracle10g, I can use DBMS_MONITOR package instead of cryptic and poorly documented oradebug. On Oracle9i, the same thing can be done by using DBMS_SUPPORT, which can be installed by using $ORACLE_HOME/rdbms/admin/dbmssupp.sql. Also, in order to make looking for the file easier, one could use "ALTER SESSION SET TRACEFILE_IDENTIFIER=<ident>". Furthermore, if you go to my web page, you will find an article about oradebug.
The question still remains: is there a way to see SQL commands executed by the background processes in V$SQL?

-- 
http://www.mladen-gogala.com