redo log file ±¸¼º ¸ð´ÏÅÍ
-. ¸®µÎ·Î±×ÆÄÀÏ Å©±â Á¶ÀýÇÏ¿© °æÇÕ ÃÖ¼ÒÈ
-. ´ë±â¸¦ ÁÙÀÏ ¼ö ÀÖ´Â ÃæºÐÇÑ ¸®µÎ·Î±× ±×·ì »ý¼º
-. °í¼ÓÀÇ °³º° ÀåÄ¡¿¡ ¸®µÎ·Î±×ÆÄÀÏ »ý¼º
SQL> select * 2 from v$logfile;
GROUP# STATUS TYPE MEMBER------------------------------------------------------ 1 ONLINE /dev/xxxrredo01
1 ONLINE /dev/xxxrredo11
2 ONLINE /dev/xxxrredo02
2 ONLINE /dev/xxxrredo12
3 ONLINE /dev/xxxrredo03
3 ONLINE /dev/xxxrredo13
6 rows selected.
SQL> select * 2 from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM 1 1 5212 262144000 2 NO CURRENT 9.2628E+12 20-SEP-07 2 1 5210 262144000 2 YES INACTIVE 9.2628E+12 20-SEP-07 3 1 5211 262144000 2 YES INACTIVE 9.2628E+12 20-SEP-07
SQL> select * 2 from v$log_history;
RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#---------- ---------- ---------- ---------- ------------- --------- ------------ 1 614546853 1 1 1 14-FEB-07 61473 2 615554215 1 2 61473 14-FEB-07 9.2252E+12 3 615554574 1 3 9.2252E+12 26-FEB-07 9.2252E+12 4 615554744 1 4 9.2252E+12 26-FEB-07 9.2252E+12 5 615555373 1 5 9.2252E+12 26-FEB-07 9.2252E+12 6 615555516 1 6 9.2252E+12 26-FEB-07 9.2252E+12 7 615555662 1 7 9.2252E+12 26-FEB-07 9.2252E+12 8 615555813 1 8 9.2252E+12 26-FEB-07 9.2252E+12
SQL> select * 2 from v$system_event 3 where event = 'log file parallel write' 4 ;
EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO-------------------------------------------------------------------------log file parallel write 37894538 0 224024 0 2240235620
SQL>
ÁÁÀº»ý°¢ ^^