OBJECT_NAME OWNER OBJECT_TYPE
------------------------------ ------------------------------ -------------------
ALERT_QUE$1 SYS RULE SET
ALERT_QUE$1 SYS RULE
AQ$_KUPC$DATAPUMP_QUETAB_V SYS EVALUATION CONTEXT
DBMS_AW_EXP SYS PACKAGE BODY
DBMS_AW_STATS SYS PACKAGE BODY
STREAMS$_EVALUATION_CONTEXT SYS EVALUATION CONTEXT
AQ$_SYS$SERVICE_METRICS_TAB_V SYS EVALUATION CONTEXT
SYS$SERVICE_METRICS_R SYS RULE SET
SYS$SERVICE_METRICS_N SYS RULE SET
MGMT_RESPONSE DBSNMP PACKAGE BODY
DBMS_JDM_INTERNAL SYS PACKAGE BODY
OBJECT_NAME OWNER OBJECT_TYPE
------------------------------ ------------------------------ -------------------
AQ$_KUPC$DATAPUMP_QUETAB_1_V SYS EVALUATION CONTEXT
SQL>@?/rdbms/admin/utlrp.sql
如果不幸的是我们在出现问题的时候尝试重启数据库，就会发现数据库就起不来了。
SQL> drop table dual;
Table dropped.
SQL> select sysdate from dual;
select sysdate from dual
*
ERROR at line 1:
ORA-01775: looping chain of synonyms
SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 313159680 bytes
Fixed Size 2227944 bytes
Variable Size 255852824 bytes
Database Buffers 50331648 bytes
Redo Buffers 4747264 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01775: looping chain of synonyms
Process ID: 434
Session ID: 237 Serial number: 5