Oracle10g闪回恢复区详解
2007-05-09 12:13:37 来源:WEB开发网核心提示: DBA_OUTSTANDING_ALERTS 视图的存在体现了 Oracle 愈加人性化的一面,我们先来看一下该视图的基本结构,Oracle10g闪回恢复区详解(3),后面会用到,SQL> DESC dba_outstanding_alertsNameNull?Type---SEQU
DBA_OUTSTANDING_ALERTS 视图的存在体现了 Oracle 愈加人性化的一面。我们先来看一下该视图的基本结构,后面会用到。
SQL> DESC dba_outstanding_alerts
Name Null? Type
------------------------------- ----------------------------
SEQUENCE_ID NUMBER
REASON_ID NOT NULL NUMBER
OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(513)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_TYPE VARCHAR2(64)
REASON VARCHAR2(4000)
TIME_SUGGESTED TIMESTAMP(6) WITH TIME ZONE
CREATION_TIME TIMESTAMP(6) WITH TIME ZONE
SUGGESTED_ACTION VARCHAR2(4000)
ADVISOR_NAME VARCHAR2(30)
METRIC_VALUE NUMBER
MESSAGE_TYPE VARCHAR2(12)
MESSAGE_GROUP VARCHAR2(64)
MESSAGE_LEVEL NUMBER
HOSTING_CLIENT_ID VARCHAR2(64)
MODULE_ID VARCHAR2(64)
PROCESS_ID VARCHAR2(128)
HOST_ID VARCHAR2(256)
HOST_NW_ADDR VARCHAR2(256)
INSTANCE_NAME VARCHAR2(16)
INSTANCE_NUMBER NUMBER
USER_ID VARCHAR2(30)
EXECUTION_CONTEXT_ID VARCHAR2(60)
ERROR_INSTANCE_ID VARCHAR2(142)
SQL>
10g 的新视图 V$RECOVERY_FILE_DEST 包含闪回恢复区的相关信息:
更多精彩
赞助商链接