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 vote189 views1 answer
Delete * from where id = 1;
SQL
0 vote160 views1 answer
Mysql sleep connections
SQL
0 vote228 views2 answers
Mysql cast to varchar
SQL
0 vote175 views1 answer
Php delete database
SQL
0 vote200 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote252 views1 answer
Reindexing all tables sql server
SQL
0 vote146 views1 answer
Import sql file in mysql linux
SQL
2 votes184 views6 answers
In in sql
SQL
1 vote184 views2 answers
Postgresql list columns
SQL
0 vote242 views1 answer
CONVERT time string into 12 hours in sql
SQL