-------------------------------------------------------------------------------- SELECT GROUP#, STATUS, TYPE, MEMBER, IS_RECOVERY_DEST_FILE FROM GV$LOGFILE ORDER BY GROUP#, MEMBER; -------------------------------------------------------------------------------- SELECT * FROM V$LOG ORDER BY GROUP#; -------------------------------------------------------------------------------- SELECT A.GROUP#, A.MEMBER, B.STATUS, B.BYTES/1024/1024 AS MBytes FROM V$LOGFILE A, V$LOG B WHERE A.GROUP# = B.GROUP# ORDER BY A.GROUP#, A.MEMBER; -------------------------------------------------------------------------------- SELECT * FROM V$LOG_HISTORY ORDER BY SEQUENCE# DESC; --------------------------------------------------------------------------------
댓글
댓글 쓰기