redo wait => sga ¿µ¿ªÁß
ÀÛ¼ºÀÚ °ü¸®ÀÚ ÀÛ¼º½Ã°£ 2006-03-14 15:35:30
 

select r.value "Retries", e.value "Entries", r.value/e.value*100 "Percentage"
from v$sysstat r,v$sysstat e
where r.name = 'redo buffer allocation retries'
and e.name = 'redo entries'
/

  Retries    Entries Percentage
---------- ---------- ----------
        8    1476944 .000541659    <-- 1º¸´Ù À۾ƾßÇÑ´Ù.

±×·¸Áö ¾Ê´Ù¸é log_buffer °ªÀ» ¿Ã·Á¾ß ÇÑ´Ù.


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦