Oracle archivelog usage

WITH hours AS (
    SELECT trunc(sysdate) + ((LEVEL - 1) / 24) AS HOURS
    FROM DUAL
    CONNECT BY LEVEL < = 24
)
SELECT h.HOURS AS DATE_HOUR,
    round(sum(BLOCKS * BLOCK_SIZE) / 1e9, 2) SIZE_GB
FROM hours h
    LEFT OUTER JOIN V$ARCHIVED_LOG al ON h.HOURS = trunc(al.FIRST_TIME, 'HH24')
GROUP BY h.HOURS
ORDER BY h.HOURS;

Similar codes

0 vote159 views2 answers
Mysql row_number() example
SQL
1 vote152 views3 answers
Rows, INSERT INTO
SQL
0 vote138 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote172 views1 answer
Sql get latest of 2 datetimes
SQL
3 votes140 views1 answer
Create a table with an id in mysql
SQL
10 votes105 views2 answers
Mysql select timestamp group by day
SQL
0 vote132 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
3 votes134 views1 answer
Sql replace character in string in all records
SQL
1 vote141 views1 answer
Mysql list bigger table
SQL
2 votes138 views1 answer
Postgresql add entry to table
SQL