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>
>
> 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).
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 GroupReceived on Sun Oct 01 2006 - 00:02:24 CDT