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
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 | 31 |
wordman512 on Grouping with Rollup | |
heliodias on AWR it´s not free and requires… | |
Venkata on AWR it´s not free and requires… | |
jsixface on Best way to delete millions ro… | |
heliodias on What objects should go to… |