V$LOGFILE描述的是组中成员的信息
Sql> select * from v$logfile;
![](http://img.blog.itpub.net/blog/attachment/201503/31/29840459_1427763572eZss.jpg?x-oss-process=style/bb)
V$LOG描述的是组的信息
sql>desc v$log;
sql>select group#,thread#,sequence# from v$log;--查看当前的组个数,序号等。
![](http://img.blog.itpub.net/blog/attachment/201503/31/29840459_1427763572e2jJ.jpg?x-oss-process=style/bb)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29840459/viewspace-1479649/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29840459/viewspace-1479649/