Re: Oracle BG processes and SQL visibility in 10.2.0.2

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 30 Sep 2006 22:02:24 -0700
Message-ID: <1159678941.7455@bubbleator.drizzle.com>

Luso Joe wrote:
> 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).

This is demonstratably not true.

SQL> SELECT service, COUNT(*)

   2 FROM gv$sql
   3 GROUP BY service;

SERVICE COUNT(*)

---------------- ----------
orabase          120
SYS$BACKGROUND   483
SYS$USERS        930

SQL>

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Sun Oct 01 2006 - 00:02:24 CDT