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 vote265 views1 answer
Power query case when
SQL
3 votes268 views3 answers
Concatenation in sql
SQL
5 votes293 views4 answers
Upload database mysql command line
SQL
0 vote279 views1 answer
How to add unique key constraint in mysql
SQL
5 votes290 views1 answer
Invalid column name sql
SQL
0 vote277 views1 answer
SQL SELECT-Klausel
SQL
2 votes279 views6 answers
Mysql change timezone
SQL
0 vote289 views1 answer
Sql cmd no truncate
SQL
1 vote285 views1 answer
Wordpress change http to https phpmyadmin
SQL
2 votes273 views1 answer
Date conversion in mysql column
SQL