Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Job Queue processes

Job Queue processes

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 12 Sep 2007 14:09:25 GMT
Message-ID: <46e7f315$0$1343$834e42db@reader.greatnowhere.com>


Oracle 10.2.0.3, Linux.

  1* select program,event,status,state,seconds_in_wait from v$session where sid=135
SQL> /

PROGRAM                   EVENT                          STATUS   
STATE               SECONDS_IN_WAI
------------------------- ------------------------------ -------- 
------------------- --------------
oracle_at_oracle10 (J000)    jobq slave wait                ACTIVE   
WAITING                        222



Now, what's the problem with this picture? Status of the process is listed as "active", despite the fact that it doesn't execute any SQL. If it was executing SQL, it wouldn't be waiting for something to do ("jobq slave wait"), it would be waiting for db file .* read, latch, enqueue or something else usually seen during the SQL execution. Why is this process marked as active and what exactly is it executing? Strace confirms that it's executing an idle loop, scanning the queues for some work to do.

-- 
http://www.mladen-gogala.com
Received on Wed Sep 12 2007 - 09:09:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US