V$LOG
V$LOG displays log file information from the control file.
Column | Datatype | Description |
---|---|---|
GROUP# | NUMBER | Log group number |
THREAD# | NUMBER | Log thread number |
SEQUENCE# | NUMBER | Log sequence number |
BYTES | NUMBER | Size of the log (in bytes) |
MEMBERS | NUMBER | Number of members in the log group |
ARCHIVED | VARCHAR2(3) | Archive status (YES or NO) |
STATUS | VARCHAR2(16) | Log status:
|
FIRST_CHANGE# | NUMBER | Lowest system change number (SCN) in the log |
FIRST_TIME | DATE | Time of the first SCN in the log |
V$LOGFILE
This view contains information about redo log files.
Column | Datatype | Description |
---|---|---|
GROUP# | NUMBER | Redo log group identifier number |
STATUS | VARCHAR2(7) | Status of the log member:
|
TYPE | VARCHAR2(7) | Type of the logfile:
|
MEMBER | VARCHAR2(513) | Redo log member name |
IS_RECOVERY_DEST_FILE | VARCHAR2(3) | Indicates whether the file was created in the flash recovery area (YES) or not (NO) |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10714335/viewspace-374820/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10714335/viewspace-374820/