Note: ORA 600 [kkzgajvm_getCountStarSel:1 (Doc ID 2194072.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Caused by: java.sql.SQLException: ORA-12048: error encountered while refreshing materialized view "INAUTH_RISK_USER"."TOP_BROWSER_TYPES"
ORA-00600: internal error code, arguments: [kkzgajvm_getCountStarSel:1], [], [], [], [], [], [], [], [], [], [], []

*** CONTAINER ID:(3) 2016-04-14 12:01:05.473
  
 DDE: Problem Key 'ORA 600 [kkzgajvm_getCountStarSel:1]' was flood controlled (0x2) (incident: 7346)
 ORA-00600: internal error code, arguments: [kkzgajvm_getCountStarSel:1], [], [], [], [], [], [], [], [], [], [], []
 
 *** 2016-04-14 12:01:05.474
 dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)

...
SELECT BROWSER_TYPE, site_key, COUNT(1) as TOTAL FROM
device_info join transaction_info ON transaction_info.ID = device_info.TRANSACTION_ID
GROUP BY browser_type, site_key
...

Stack Trace:
  dbgdaExecuteAction                 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms