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

Source: Internet
Author: User
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;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.