Re: Oracle BG processes and SQL visibility in 10.2.0.2

On Sat, 30 Sep 2006 23:43:22 GMT, Mladen Gogala <mgogala.spam-me-not_at_verizon.net> wrote:

>The question still remains: is there a way to see SQL commands executed by
>the background processes in V$SQL?

No. The major background processes such as SMON, PMON, etc, do not execute SQL as such. Therefore there is nothing to be exposed through v$sql. SQL is processed in the server processes, not the background processes (except thing like job queue processes which exist to process database operations, rather than the Oracle server code). Received on Sat Sep 30 2006 - 22:49:15 CDT