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

1 vote266 views3 answers
Uninstall postgresql mac
SQL
1 vote159 views1 answer
Oracle create program if no exists
SQL
1 vote153 views10 answers
Stack overflow
SQL
-1 vote243 views5 answers
Left join sql
SQL
0 vote191 views1 answer
Check database restore status sql script
SQL
10 votes153 views1 answer
Oracle view dependencies
SQL
0 vote167 views1 answer
How to find database collation in postgres
SQL
18 votes156 views4 answers
Mysql current date between two dates
SQL
1 vote153 views1 answer
Postgresql convert text to float
SQL
0 vote162 views1 answer
Mssql disable foreign key constraint
SQL