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 vote355 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
-1 vote346 views3 answers
Psql get last rows
SQL
0 vote355 views1 answer
Oracle job class
SQL
1 vote377 views1 answer
Setval pgsql
SQL
2 votes313 views1 answer
Oracle current date without time
SQL
4 votes343 views2 answers
Sql table
SQL
0 vote384 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote365 views1 answer
Sql output select
SQL
5 votes390 views4 answers
Traduction
SQL
5 votes362 views1 answer
Oracle sysdate - 1 month
SQL