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。