oracle 视图 日志,23.Oracle杂记——Oracle常用动态视图v$log

23.Oracle杂记——Oracle常用动态视图v$log

视图v$log：从控制文件中提取有关重做日志组的信息

描述如下：

sys@PDB1> desc v$log;

Name                                                                                                     Null?         Type

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

GROUP#                                                                                                                           NUMBER

THREAD#                                                                                                                           NUMBER

SEQUENCE#                                                                                                                     NUMBER

BYTES                                                                                                                                 NUMBER

BLOCKSIZE                                                                                                                        NUMBER

MEMBERS                                                                                                                        NUMBER

ARCHIVED                                                                                                                         VARCHAR2(3)

STATUS                                                                                                                            VARCHAR2(16)

FIRST_CHANGE#                                                                                                                              NUMBER

FIRST_TIME                                                                                                                     DATE

NEXT_CHANGE#                                                                                                             NUMBER

NEXT_TIME                                                                                                                      DATE

CON_ID                                                                                                                           NUMBER

各个列属性如下：

GROUP#：日志组号

THREAD#：日志进程号

SEQUENCE#         ：日志序列号

BYTES：日志大小(字节)

BLOCKSIZE：日志块大小

MEMBERS：日志组中成员数量

ARCHIVED：是否归档

STATUS                ：日志状态

FIRST_CHANGE#：日志中最小的SCN

FIRST_TIME：最小SCN的时间

NEXT_CHANGE#：日志中最大的SCN

NEXT_TIME：最好SCN的时间

CON_ID ：拥有该数据的容器ID。