My Oracle Support Banner

Bug 18511269 : ORA-600 [KKSGAGETNOALLOC_INT0] RUNNING WORKLOAD & ONLINE REDEF CONCURRENTLY (Doc ID 2175884.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

Following error is reported on the alert log and trace file may contain the following information:

Dump continued from file: /u01/app/oracle/diag/rdbms/flowr/FLOWR2/trace/FLOWR2_ora_31705.trc
[TOC00001]
ORA-00600: internal error code, arguments: [kksgaGetNoAlloc_Int0], [11], [11], [], [], [], [], [], [], [], [], []

----- Current SQL Statement for this session (sql_id=4b4wp0a8dvkf0) -----
SELECT executions, end_of_fetch_count, elapsed_time/px_servers elapsed_time, cpu_time/px_servers cpu_time, buffer_gets/executions buffer_gets FROM (SELECT sum(executions_delta) as EXECUTIONS, sum(case when px_servers_execs_delta > 0 then px_servers_execs_delta else executions_delta end) as px_servers, sum(end_of_fetch_count_delta) as end_of_fetch_count, sum(elapsed_time_delta) as ELAPSED_TIME, sum(cpu_time_delta) as CPU_TIME, sum(buffer_gets_delta) as BUFFER_GETS FROM DBA_HIST_SQLSTAT s, V$DATABASE d, DBA_HIST_SNAPSHOT sn WHERE s.dbid = d.dbid AND bitand(nvl(s.flag, 0), 1) = 0 AND sn.end_interval_time > (select systimestamp at TIME ZONE dbtimezone from dual) - 7 AND s.sql_id = :1 AND s.snap_id = sn.snap_id AND s.instance_number = sn.instance_number AND s.dbid = sn.dbid AND parsing_schema_name = :2)
[TOC00004-END]

client details:
O/S info: user:*** , term: , ospid: 31700
machine: *** 3012 program: perl@***** (TNS V1-V3)
application name: Oracle Enterprise Manager.Metric Engine, hash value=2371535196

 

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.