合 V$LOG视图中STATUS列的值有哪几种含义?
1 2 3 4 5 6 7 8 9 10 11 12 | SYS@ora11g> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- 1 1 6752 52428800 512 2 YES INACTIVE 3.3349E+10 2022-11-16 14:52:49 3.3349E+10 2022-11-16 15:09:03 2 1 6753 52428800 512 2 YES INACTIVE 3.3349E+10 2022-11-16 15:09:03 3.3349E+10 2022-11-16 15:39:03 3 1 6754 52428800 512 2 YES INACTIVE 3.3349E+10 2022-11-16 15:39:03 3.3349E+10 2022-11-16 15:39:05 14 1 6750 52428800 512 2 YES INACTIVE 3.3349E+10 2022-11-16 14:39:53 3.3349E+10 2022-11-16 14:50:06 15 1 6751 52428800 512 2 YES INACTIVE 3.3349E+10 2022-11-16 14:50:06 3.3349E+10 2022-11-16 14:52:49 16 1 6755 52428800 512 2 NO CURRENT 3.3349E+10 2022-11-16 15:39:05 2.8147E+14 6 rows selected. |
STATUS列的值有如下6种含义: