|
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 °ªÀ» ¿Ã·Á¾ß ÇÑ´Ù.
|