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
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
No comments yet.
Leave a Reply