WebLogic timers query held in infinite wait
We are experiencing a strange behaviour of a WebLogic Cluster with Oracle DB.
We monitor the waiting SQL statements with:
SELECT
s.sid,
s.serial#,
p.spid,
s.username,
s.program,
s.machine,
s.event,
s.seconds_in_wait,
/*+ ORDERED USE_NL(st) */ q.sql_text
FROM v$session s
JOIN v$process p ON p.addr = s.paddr
JOIN v$sqltext q ON q.address = s.sql_address and q.hash_value=s.sql_hash_value
WHERE s.type != 'BACKGROUND'
order by s.seconds_in_wait desc, s.sid, q.piece;
The following statement
SELECT TIMER_ID FROM weblogic_timers WHERE START_TIME < 1341905693752 AND DOMAIN_NAME=? AND CLUSTER_NAME=?
We monitor the waiting SQL statements with:
SELECT
s.sid,
s.serial#,
p.spid,
s.username,
s.program,
s.machine,
s.event,
s.seconds_in_wait,
/*+ ORDERED USE_NL(st) */ q.sql_text
FROM v$session s
JOIN v$process p ON p.addr = s.paddr
JOIN v$sqltext q ON q.address = s.sql_address and q.hash_value=s.sql_hash_value
WHERE s.type != 'BACKGROUND'
order by s.seconds_in_wait desc, s.sid, q.piece;
The following statement
SELECT TIMER_ID FROM weblogic_timers WHERE START_TIME < 1341905693752 AND DOMAIN_NAME=? AND CLUSTER_NAME=?
0