WEB开发网
开发学院数据库Oracle Oracle10g闪回恢复区详解 阅读

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 包含闪回恢复区的相关信息:

上一页  1 2 3 4 5  下一页

Tags:Oracleg 恢复 详解

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接