浅谈Oracle10G闪回恢复区　（下）

文章作者 100test 发表时间 2007:03:14 13:42:05
来源 100Test.Com百考试题网

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

SQL> desc V$RECOVERY_FILE_DEST

Name Null? Type

-----------------------------------------------------------------------------

NAME VARCHAR2(513)

SPACE_LIMIT NUMBER

SPACE_USED NUMBER

SPACE_RECLAIMABLE NUMBER

NUMBER_OF_FILES NUMBER

SQL> SELECT NAME, space_limit, space_used, space_reclaimable space_rec,

2 number_of_files file_num

3 FROM v$recovery_file_dest.

NAME SPACE_LIMIT SPACE_USED SPACE_REC FILE_NUM

----------------------------------------------------------------------------

/u01/app/oracle/flash_recovery_area 2147483648 1106849280 602410496 30

SQL>