Online Archive log check
------------------------------------------------------------------------------ -- Redo Log Group, Member Information -- -- CURRENT : LGWR Process is in use -- ACTIVE : LGWR Process is not in use. But Recover is necessary because of transaction spending long time -- INACTIVE : LGWR Process is not in use and Recovery is not necessary ------------------------------------------------------------------------------ SELECT GROUP# , MEMBERS , BYTES , ARCHIVED , STATUS FROM V$LOG;
------------------------------ -- Redo Log File Information ------------------------------ SELECT GROUP# , STATUS , MEMBER FROM V$LOGFILE;
No comments:
Post a Comment