ORA-600 [6947]/ORA-600 [kdsgrp1] Processing

ORA-600 [6947] ORA-600 [kdsgrp1] Processing

ORA-600 [6947]/ORA-600 [kdsgrp1] Processing

ORA-600 [6947]/ORA-600 [kdsgrp1] Processing

SQL> select * from v $ version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bi
PL/SQL Release 10.2.0.1.0-Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0-Production
NLSRTL Version 10.2.0.1.0-Production

SQL> SELECT tablespace_name, segment_type, owner, segment_name
2 FROM dba_extents
3 WHERE file_id = 3
4 and 22950 between block_id AND block_id + blocks-1;

TABLESPACE_NAME SEGMENT_TYPE OWNER
------------------------------------------------------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SYSAUX TABLE SYSMAN
MGMT_LICENSES

SQL> c/22950/37685
4 * and 37685 between block_id AND block_id + blocks-1
SQL> r
1 SELECT tablespace_name, segment_type, owner, segment_name
2 FROM dba_extents
3 WHERE file_id = 3
4 * and 37685 between block_id AND block_id + blocks-1

TABLESPACE_NAME SEGMENT_TYPE OWNER
------------------------------------------------------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SYSAUX TABLE SYSMAN
SYS_IOT_OVER_49869

SQL> select table_name, iot_name from all_tables where table_name like '% IOT % ';

TABLE_NAME IOT_NAME
------------------------------------------------------------
SYS_IOT_OVER_4478 RULE_SET_PR $
SYS_IOT_OVER_4484 RULE_SET_IOT $
SYS_IOT_OVER_4488 RULE_SET_ROP $
SYS_IOT_OVER_5082 AQ $ _ SCHEDULER $ _ JOBQTAB_G
SYS_IOT_OVER_5168 AQ $ _ SCHEDULER $ _ EVENT_QTAB_G
SYS_IOT_OVER_7157 AQ $ _ KUPC $ DATAPUMP_QUETAB_G
SYS_IOT_OVER_8689 AQ $ _ MEM_MC_G
SYS_IOT_OVER_8799 AQ $ _ ALERT_QT_G
SYS_IOT_OVER_9692 RECENT_RESOURCE_INCARNATIONS $
SYS_IOT_OVER_10099 AQ $ _ WM $ EVENT_QUEUE_TABLE_G
SYS_IOT_OVER_35428 AQ $ _ SYS $ SERVICE_METRICS_TAB_G

TABLE_NAME IOT_NAME
------------------------------------------------------------
SYS_IOT_OVER_40409 EXF $ IDXSECOBJ
SYS_IOT_OVER_40883 DR $ SQE
SYS_IOT_OVER_40928 DR $ PARALLEL
Sys_iot_over_000045 RLM $ ERRCODE
Sys_iot_over_000052 RLM $ RULESET
Sys_iot_over_000059 RLM $ PRIMEVTTYPEMAP
Sys_iot_over_000062 RLM $ export spec
Sys_iot_over_000081 RLM $ JOBQUEUE
Sys_iot_over_000084 RLM4J $ EVTSTRUCTS
Sys_iot_over_000087 RLM4J $ RULESET
Sys_iot_over_000090 RLM4J $ ATTRALIASES

TABLE_NAME IOT_NAME
------------------------------------------------------------
SYS_IOT_OVER_49766 AQ $ _ mgmt_policy_qtable_g
SYS_IOT_OVER_49869 MGMT_METRICS_RAW
SYS_IOT_OVER_49872 MGMT_CURRENT_METRICS
SYS_IOT_OVER_52389 ACTION_TABLE
SYS_IOT_OVER_52394 LINEITEM_TABLE
SYS_IOT_OVER_52776 AQ $ _ KUPC $ DATAPUMP_QUETAB_D
RULE_SET_IOT $
SYS_IOT_OVER_51984 AQ $ _ STREAMS_QUEUE_TABLE_G
SYS_IOT_OVER_51967 AQ $ _ ORDERS_QUEUETABLE_G

31 rows selected.

SQL> create table SYSMAN. MGMT_METRICS_RAW_COPY
2 as select * from SYSMAN. MGMT_METRICS_RAW;