Re: Oracle BG processes and SQL visibility in

From: DA Morgan <>
Date: Sat, 30 Sep 2006 22:02:24 -0700
Message-ID: <>

Luso Joe wrote:
> On Sat, 30 Sep 2006 23:43:22 GMT, Mladen Gogala
> <> 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).

This is demonstratably not true.

SQL> SELECT service, COUNT(*)

   2 FROM gv$sql
   3 GROUP BY service;


---------------- ----------
orabase          120
SYS$USERS        930


Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Sun Oct 01 2006 - 00:02:24 CDT

Original text of this message