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

2 votes121 views1 answer
Oracle number to percentage
SQL
0 vote129 views1 answer
Mysql two joins
SQL
4 votes156 views3 answers
Postgres drop all tables
SQL
0 vote119 views1 answer
Sql date between one week
SQL
0 vote123 views1 answer
Uuid sqlalcomany
SQL
16 votes145 views3 answers
Get count of duplicate records
SQL
4 votes216 views1 answer
What are the data types
SQL
2 votes202 views1 answer
Postgresql group by month and year
SQL
0 vote139 views2 answers
Replace null with 0 in sql
SQL
4 votes135 views1 answer
Wilayah indonesia database
SQL