Re: Oracle BG processes and SQL visibility in 10.2.0.2
Date: Sat, 30 Sep 2006 22:02:24 -0700
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;
---------------- ---------- orabase 120 SYS$BACKGROUND 483 SYS$USERS 930
-- Daniel Morgan University of Washington Puget Sound Oracle Users GroupReceived on Sun Oct 01 2006 - 00:02:24 CDT