Oracle Logbook

March 31, 2009

Finding the frequency of log switch

Filed under: Uncategorized — heliodias @ 3:25 pm

select qtd,count(*) from (
select trunc(FIRST_TIME),trunc(count(*)/10)*10 qtd
from  v$log_history group by trunc(FIRST_TIME) order by 2
)group by qtd order by 1;

Usually is good pratice make 2 log switchs per hour

Advertisements

Create a free website or blog at WordPress.com.