My Oracle Support Banner

ORA-00600 [17147] ORA-48216 When Querying V$DIAG_ALERT_EXT View (Doc ID 2119059.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Errors reported:

ORA-00600: internal error code, arguments: [17147], [0x110A09510], [], [], [], [], [], [], [], [], [], []
ORA-48216: Field Len Exceeds Max Field Length [5] [30] [29286] [66]

Current SQL Statement is accessing v$diag_alert_ext like the below:

select inst_id,
originating_timestamp,
message_text, '1'
from table (gv$ (cursor (select inst_id, originating_timestamp, message_text
from v$diag_alert_ext a
where originating_timestamp > ( sysdate - 1 )
and ( message_text like '%ORA-%'
or message_text like '%CRS-%' ))))
order by originating_timestamp desc;

Call stack contains:

.. kghfrf dbgripfrm_free_mem dbgripsit2_stop_iterator_2 dbgripsit_stop_iterator_p dbgripicl_iter_cleanup dbgrip_relation_iterator qerfxFetch ...

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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