查看在线日志文件信息¶
使用以下视图显示在线日志文件信息（具体语法参见SQL语言参考手册）：
| 视图 | 说明 |
|---|---|
| V_SYS_LOGFILE_INFO | 在线日志文件信息 |
| V_SYS_LOGSEGMENT_INFO | 在线日志文件段信息 |
以下查询将返回控制文件中关于在线日志文件的信息
SELECT * FROM V_SYS_LOGFILE_INFO;
----------------------------------------------------------------------------------------------------------------
FILEID | CREATIONTIME | REALSIZE | INITSIZE | MAXSIZE | SCALEEXTEND | NEXTSIZE | USAGERATIO | ISACTIVE | PATH
0 | 2012-03-09 14:49:41 | 104857600 | 104857600 | 2199023255040 | t | 10 | 5.66 | ON LINE | d:\\ShenTong\\odbs\\OSRDB\\OSRDB01.log
1 | 2012-03-13 12:21:25 | 104857600 | 104857600 | 2199023255040 | t | 10 | 0| OFF LINE | d:\\ShenTong\\odbs\\OSRDB\\OSRDB02.log
----------------------------------------------------------------------------------------------------------------
以下查询将返回控制文件中关于在线日志文件的信息
SELECT * FROM V_SYS_LOGSEGMENT_INFO;
FILEID | SEGID | SEGSIZE | SEGOFFSET | STARTLSN | STATUS | SEGTYPE
--------+-------+----------+-----------+----------+--------+-----------------
0 | 0 | 13107200 | 512 | 8860672 | inuse | internal origin
0 | 1 | 13107200 | 13107712 | 0 | reuse | internal origin
0 | 2 | 13107200 | 26214912 | 0 | reuse | internal origin
0 | 3 | 13107200 | 39322112 | 0 | reuse | internal origin
0 | 4 | 13107200 | 52429312 | 0 | reuse | internal origin
0 | 5 | 13107200 | 65536512 | 0 | reuse | internal origin
0 | 6 | 13107200 | 78643712 | 0 | reuse | internal origin
0 | 7 | 13107200 | 91750912 | 0 | reuse | internal origin
0 | 8 | 13107200 | 104858112 | 0 | reuse | internal origin
0 | 9 | 13107200 | 117965312 | 0 | reuse | internal origin
0 | 10 | 13107200 | 131072512 | 0 | reuse | internal origin
0 | 11 | 13107200 | 144179712 | 0 | reuse | internal origin
0 | 12 | 13107200 | 157286912 | 0 | reuse | internal origin
----------------------------------------------------------------------------------------------------------------