07445: [Lsrsrt()+786] (Doc ID 1366345.1)

Symptoms

When attempting to a SQL statement similar to this one;
/* OracleOEM */
select capture_name streams_name,'capture' streams_type , (available_message_create_time-capture_message_create_time)*86400 latency,
nvl(total_messages_enqueued,0) total_messages from gv$streams_capture
union all
select propagation_name streams_name,'propagation' streams_type,last_lcr_latency latency , total_msgs total_messages
from gv$propagation_sender where propagation_name is not null
union all
SELECT apc.apply_name as STREAMS_NAME,
'apply' as STREAMS_TYPE,
CASE WHEN aps.state != 'IDLE' THEN
nvl((aps.apply_time - aps.create_time)*86400, -1)
WHEN apc.state != 'IDLE' THEN
nvl((apc.apply_time - apc.create_time)*86400, -1)
WHEN apr.state != 'IDLE' THEN
nvl((apr.apply_time - apr.create_time)*86400, -1)
ELSE 0
END as STREAMS_LATENCY,
nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES
FROM ( SELECT apply_name,
state,
apply_time,
applied_message_create_time as create_time,
total_messages_applied
FROM ( SELECT apply_name,
state,
apply_time,
applied_message_create_time,
MAX(applied_message_create_time)
OVER (PARTITION BY apply_name)
as max_create_time,
SUM(total_messages_applied)
OVER (PARTITION BY apply_name)
as total_messages_applied
FROM gv$streams_apply_server )
WHERE MAX_CREATE_TIME||'X' =
APPLIED_MESSAGE_CREATE_TIME||'X' ) aps,
( SELECT apply_name,
state,
lwm_time as apply_time,
lwm_message_create_time as create_time
FROM gv$streams_apply_coordinator ) apc,
( SELECT apply_name,
state,
dequeue_time as apply_time,
dequeued_message_create_time as create_time
FROM gv$streams_apply_reader ) apr
WHERE apc.apply_name = apr.apply_name AND
apr.apply_name = aps.apply_name

the following error occurs.

ERROR
-----------------------
ORA-07445: exception encountered: core dump [lsrsrt()+786] [SIGILL] [ADDR:0x4000000010516512] [PC:0x4000000010516512] [Register NaT Consumption] []

Some or all of the following function codes may be seen in the "Call Stack Trace" section of the trace file:

 
lsrsrt kkoOrdTbBySize kkoiqb kkooqb kkoqbc apakkoqb apaqbdDescendents apaqbdList apaqbdDescendents apaqbd kkofkrSetup kkqctCostTransfQB kkqctdrvSU kkqutruns kkqutruns kkqudrv kkqctdrvTD kkqdrv kkqctdrvIT apadrv opitca kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main main_opd_entry

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.