v$LOG视图

Maclean Liu(刘相兵

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)
BLOCKSIZE	NUMBER	Block size of the logfile (512 or 4096)
MEMBERS	NUMBER	Number of members in the log group
ARCHIVED	VARCHAR2(3)	Archive status (YES) or (NO)
STATUS	VARCHAR2(16)	Log status: UNUSED - Online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log. CURRENT - Current redo log. This implies that the redo log is active. The redo log could be open or closed. ACTIVE - Log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It may or may not be archived. CLEARING - Log is being re-created as an empty log after an ALTER DATABASE CLEAR LOGFILE statement. After the log is cleared, the status changes to UNUSED. CLEARING_CURRENT - Current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header. INACTIVE - Log is no longer needed for instance recovery. It may be in use for media recovery. It may or may not be archived.
FIRST_CHANGE#	NUMBER	Lowest system change number (SCN) in the log
FIRST_TIME	DATE	Time of the first SCN in the log

Maclean Liu(刘相兵

v$log 其信息来源于 x$kccle 和  x$kccrt

x$kccle—- [K]ernel [C]ache [C]ontrolfile management [L]ogfil[E] record
X$KCCRT - [R]edo [T]hread Information

Gv$LOG  在10.2.0.1中的定义

1. select le.inst_id,
   
2.        le.lenum,
   
3.        le.lethr,
   
4.        le.leseq,
   
5.        le.lesiz * le.lebsz,
   
6.        ledup,
   
7.        decode(bitand(le.leflg, 1), 0, 'NO', 'YES'),
   
8.        decode(bitand(le.leflg, 24),
   
9.               8,
   
10.               'CURRENT',
    
11.               16,
    
12.               'CLEARING',
    
13.               24,
    
14.               'CLEARING_CURRENT',
    
15.               decode(sign(leseq),
    
16.                      0,
    
17.                      'UNUSED',
    
18.                      decode(sign((to_number(rt.rtckp_scn) -
    
19.                                  to_number(le.lenxs)) * bitand(rt.rtsta, 2)),
    
20.                             -1,
    
21.                             'ACTIVE',
    
22.                             'INACTIVE'))),
    
23.        to_number(le.lelos),
    
24.        to_date(le.lelot, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')
    
25.   from x$kccle le, x$kccrt rt
    
26. where le.ledup != 0
    
27.    and le.lethr = rt.rtnum
    
28.    and le.inst_id = rt.inst_id

复制代码