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

3 votes320 views2 answers
Search text in all sql server stored procedure
SQL
25 votes304 views5 answers
Uninstall mysql ubuntu
SQL
8 votes301 views1 answer
Unique vs primary key
SQL
2 votes318 views4 answers
Mysql get all tables row count
SQL
2 votes324 views2 answers
Convert_tz mysql
SQL
0 vote326 views1 answer
Print hello world in plsql
SQL
3 votes344 views1 answer
Sql double index
SQL
0 vote314 views1 answer
Suse status MySQL
SQL
3 votes292 views1 answer
Mysql load sql from file
SQL
16 votes314 views4 answers
Ascending order mysql
SQL