Bug 18511269 : ORA-600 [KKSGAGETNOALLOC_INT0] RUNNING WORKLOAD & ONLINE REDEF CONCURRENTLY
(Doc ID 2175884.1)
Last updated on FEBRUARY 23, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
Following error is reported on the alert log and trace file may contain the following information:
[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
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |