ORA-600[6947]/ORA-600[kdsgrp1]处理

ORA-600 [6947]/ORA-600 [kdsgrp1] 处理

ORA-600 [6947]/ORA-600 [kdsgrp1] 处理

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - bi
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_86 AQ$_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_42445 RLM$ERRCODE
SYS_IOT_OVER_42452 RLM$RULESET
SYS_IOT_OVER_42459 RLM$PRIMEVTTYPEMAP
SYS_IOT_OVER_42462 RLM$EQUALSPEC
SYS_IOT_OVER_42481 RLM$JOBQUEUE
SYS_IOT_OVER_42484 RLM4J$EVTSTRUCTS
SYS_IOT_OVER_42487 RLM4J$RULESET
SYS_IOT_OVER_42490 RLM4J$ATTRALIASES

TABLE_NAME IOT_NAME
------------------------------ ------------------------------
SYS_IOT_OVER_49766 AQ$_MGMT_NOTIFY_QTABLE_G
SYS_IOT_OVER_49869 MGMT_METRICS_RAW
SYS_IOT_OVER_49872 MGMT_CURRENT_METRICS
SYS_IOT_OVER_523 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;