Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Job Queue processes
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.comReceived on Wed Sep 12 2007 - 09:09:25 CDT
![]() |
![]() |